sp-helpsrvrolemember-transact-sql.md

title	sp_helpsrvrolemember (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_helpsrvrolemember sp_helpsrvrolemember_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_helpsrvrolemember
ms.assetid	d0714913-8d6b-4de3-b042-3ae9934f839d
author	stevestein
ms.author	sstein

sp_helpsrvrolemember (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Returns information about the members of a [!INCLUDEssNoVersion] fixed server role.

Transact-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.

All logins are a member of public. sp_helpsrvrolemember does not recognize the public role because, internally, [!INCLUDEssNoVersion] does not implement public as a role.

To add or removed members from server roles, see ALTER SERVER ROLE (Transact-SQL).

sp_helpsrvrolemember does not take a user-defined server role as an argument. To determine the members of a user-defined server role, see the examples in ALTER SERVER ROLE (Transact-SQL).

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

sp_helprole (Transact-SQL)
sp_helprolemember (Transact-SQL)
System Stored Procedures (Transact-SQL)
Security Stored Procedures (Transact-SQL)
Security Functions (Transact-SQL)