sp-addsrvrolemember-transact-sql.md

title	sp_addsrvrolemember (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/20/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_addsrvrolemember sp_addsrvrolemember_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_addsrvrolemember
ms.assetid	777f0e09-8ee5-4cb2-a3ac-939d02c3cd22
caps.latest.revision	32
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sp_addsrvrolemember (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Adds a login as a member of a fixed server role.

Important

[!INCLUDEssNoteDepFutureAvoid] Use ALTER SERVER ROLE instead.

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

Transact-SQL Syntax Conventions

Syntax

  
sp_addsrvrolemember [ @loginame= ] 'login'   
    , [ @rolename = ] 'role'  

Arguments

[ @loginame = ] 'login'
Is the name of the login being added to the fixed server role. login is sysname, with no default. login can be a [!INCLUDEssNoVersion] login or a Windows login. If the Windows login has not already been granted access to [!INCLUDEssNoVersion], access is automatically granted.

[ @rolename = ] 'role'
Is the name of the fixed server role to which the login is being added. role is sysname, with a default of NULL, and must be one of the following values:

• sysadmin

• securityadmin

• serveradmin

• setupadmin

• processadmin

• diskadmin

• dbcreator

• bulkadmin

Return Code Values

0 (success) or 1 (failure)

Remarks

When a login is added to a fixed server role, the login gains the permissions associated with that role.

The role membership of the sa login and public cannot be changed.

Use sp_addrolemember to add a member to a fixed database or user-defined role.

sp_addsrvrolemember cannot be executed within a user-defined transaction.

Permissions

Requires membership in the role to which the new member is being added.

Examples

The following example adds the Windows login Corporate\HelenS to the sysadmin fixed server role.

EXEC sp_addsrvrolemember 'Corporate\HelenS', 'sysadmin';  
GO  

See Also

Security Stored Procedures (Transact-SQL)
sp_addrolemember (Transact-SQL)
sp_dropsrvrolemember (Transact-SQL)
System Stored Procedures (Transact-SQL)
Security Functions (Transact-SQL)
CREATE SERVER ROLE (Transact-SQL)
DROP SERVER ROLE (Transact-SQL)