Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

sp_helpsrvrolemember (Transact-SQL)

Returns information about the members of a SQL Server fixed server role.

Topic link icon 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 role is 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.

Requires membership in the public role.

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

EXEC sp_helpsrvrolemember 'sysadmin'
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.