sp_helpsrvrolemember (Transact-SQL)

[ @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)

Use sp_helprolemember to display the members of a database role.

Requires membership in the public role.

The following example lists the members of the sysadmin fixed server role.

EXEC sp_helpsrvrolemember 'sysadmin'

Reference