| title | sp_helpsrvrolemember (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | d0714913-8d6b-4de3-b042-3ae9934f839d | ||
| caps.latest.revision | 27 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Returns information about the members of a [!INCLUDEssNoVersion] fixed server role.
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
Transact-SQL Syntax Conventions
sp_helpsrvrolemember [ [ @srvrolename = ] 'role' ]
[ @srvrolename = ] 'role'
Is the name of a fixed server role. role is sysname, with a default of NULL. If roleis not specified, the result set includes information about all fixed server roles.
role 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 |
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 does not recognize the public role because, internally, [!INCLUDEssNoVersion] does not implement public as a role.
To add or removed members from server roles, see ALTER SERVER ROLE (Transact-SQL).
sp_helpsrvrolemember does not 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 (Transact-SQL).
Requires membership in the public role.
The following example lists the members of the sysadmin fixed server role.
EXEC sp_helpsrvrolemember 'sysadmin';
sp_helprole (Transact-SQL)
sp_helprolemember (Transact-SQL)
System Stored Procedures (Transact-SQL)
Security Stored Procedures (Transact-SQL)
Security Functions (Transact-SQL)