sp_helpsrvrole (T-SQL)

Returns a list of the Microsoft® SQL Server™ fixed server roles.

Syntax

sp_helpsrvrole [[@srvrolename =] 'role']

Arguments

[@srvrolename =] 'role'

Is the name of the fixed server role. role is sysname, with a default of NULL, and 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

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name	Data type	Description
ServerRole	sysname	Name of the server role
Description	sysname	Description of ServerRole

Remarks

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.

The table shows stored procedures that can be used to modify server roles.

Stored procedure	Action
sp_addsrvrolemember	Adds a login account to a fixed server role.
sp_helpsrvrolemember	Displays a list of the members of a fixed server role.
sp_dropsrvrolemember	Removes a member of a server role.

Permissions

Execute permissions default to the public role.

Examples

This example shows the list of available fixed server roles.

EXEC sp_helpsrvrole