| title | sp_helpsrvrole (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/20/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 5c7f39f3-c261-4f70-8beb-08242d4ac242 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Returns a list of the [!INCLUDEssNoVersion] fixed server roles.
Transact-SQL Syntax Conventions
sp_helpsrvrole [ [ @srvrolename = ] 'role' ]
[ @srvrolename = ] 'role'
Is the name of the fixed server role. role is sysname, with a default of NULL. role can be one 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 |
| Description | sysname | Description of ServerRole |
Fixed server roles are defined at the server level and have permissions to perform specific server-level administrative activities. Fixed server roles cannot be added, removed, or changed.
To add or removed members from server roles, see ALTER SERVER ROLE (Transact-SQL).
All logins are a member of public. sp_helpsrvrole does not recognize the public role because, internally, [!INCLUDEssNoVersion] does not implement public as a role.
sp_helpsrvrole does not take a user-defined server role as an argument. To list the user-defined server roles, see the examples in ALTER SERVER ROLE (Transact-SQL).
Requires membership in the public role.
The following query returns the list of fixed server roles.
EXEC sp_helpsrvrole ;
The following query returns a list of both fixed and user-defined server roles.
SELECT * FROM sys.server_principals WHERE type = 'R' ;
The following query returns the name and description of the diskadmin fixed server roles.
sp_helpsrvrole 'diskadmin' ;
Security Stored Procedures (Transact-SQL)
Server-Level Roles
sp_addsrvrolemember (Transact-SQL)
sp_dropsrvrolemember (Transact-SQL)
sp_helpsrvrolemember (Transact-SQL)
System Stored Procedures (Transact-SQL)