Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Returns information about the members of a SQL Server fixed server role.
Transact-SQL syntax conventions
sp_helpsrvrolemember [ [ @srvrolename = ] N'srvrolename' ]
[ ; ]
The name of a fixed server role. @srvrolename is sysname, with a default of NULL, and can be any of the following 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 |
If @srvrolename isn't specified, the result set includes information about all fixed server roles.
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.
All logins are a member of public. sp_helpsrvrolemember doesn't recognize the public role because, internally, SQL Server doesn't implement public as a role.
To add or removed members from server roles, see ALTER SERVER ROLE.
sp_helpsrvrolemember doesn't take a user-defined server role as an argument. To determine the members of a user-defined server role, see the examples in ALTER SERVER ROLE.
Requires membership in the public role.
The following example lists the members of the sysadmin fixed server role.
EXEC sp_helpsrvrolemember 'sysadmin';