sp_helpsrvrolemember (Transact-SQL)

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

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_helpsrvrolemember [ [ @srvrolename = ] 'role' ]

Arguments

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

Return Code Values

0 (success) or 1 (failure)

Result Sets

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

Remarks

Use sp_helprolemember to display the members of a database role.

Permissions

Requires membership in the public role.

Examples

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

EXEC sp_helpsrvrolemember 'sysadmin'

See Also

Reference

Security Stored Procedures (Transact-SQL)
sp_addsrvrolemember (Transact-SQL)
sp_dropsrvrolemember (Transact-SQL)
sp_helprole (Transact-SQL)
sp_helprolemember (Transact-SQL)
System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance