Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

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


sp_helpsrvrole [ [ @srvrolename = ] 'role' ]


[@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
bulkadmin Can execute BULK INSERT statements

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


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.


Execute permissions default to the public role.


This example shows the list of available fixed server roles.

EXEC sp_helpsrvrole

See Also




System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft