Returns information about the members of a Microsoft® SQL Server™ fixed server role.
sp_helpsrvrolemember [ [ @srvrolename = ] 'role' ]
[@srvrolename =] 'role'
Is the name of a fixed server role about whose members information is returned. role is sysname, with a default of NULL. If role is not specified, the result set includes information regarding all fixed server roles.
role can be any of these values.
| Fixed server role | Description |
|---|---|
| sysadmin | System administrators |
| securityadmin | Security administrators |
| serveradmin | Server administrators |
| setupadmin | Setup administrators |
| processadmin | Process administrators |
| diskadmin | Disk administrators |
| dbcreator | Database creators |
| bulkadmin | Can execute BULK INSERT statements |
0 (success) or 1 (failure)
| Column name | Data type | Description |
|---|---|---|
| ServerRole | sysname | Name of the server role |
| MemberName | sysname | Name of a member of ServerRole |
| MemberSID | varbinary(85) | Security identifier of MemberName |
Use sp_helprolemember to display the members of a database role.
Execute permissions default to the public role.
This example lists the members of the sysadmin fixed server role.
EXEC sp_helpsrvrolemember 'sysadmin'