| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_helpsrvrolemember (Transact-SQL) |
sp_helpsrvrolemember returns information about the members of a SQL Server fixed server role. |
markingmyname |
maghan |
randolphwest |
05/15/2024 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Returns information about the members of a [!INCLUDE ssNoVersion] fixed server role.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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, [!INCLUDE ssNoVersion] 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';