Export (0) Print
Expand All
Expand Minimize

sp_dropsrvrolemember (Transact-SQL)

Removes a SQL Server login or a Windows user or group from a fixed server role.

Topic link icon Transact-SQL Syntax Conventions


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

[ @loginame = ] 'login'

Is the name of a login to remove from the fixed server role. login is sysname, with no default. login must exist.

[ @rolename = ] 'role'

Is the name of a server role. role is sysname, with a default of NULL. role must be one of the following values:

  • sysadmin

  • securityadmin

  • serveradmin

  • setupadmin

  • processadmin

  • diskadmin

  • dbcreator

  • bulkadmin

0 (success) or 1 (failure)

Only sp_dropsrvrolemember can be used to remove a login from a fixed server role. Use sp_droprolemember to remove a member from a database role.

The sa login cannot be removed from any fixed server role.

sp_dropsrvrolemember cannot be executed within a user-defined transaction.

Requires membership in the sysadmin fixed server role, or both ALTER ANY LOGIN permission on the server and membership in the role from which the member is being dropped.

The following example removes the login JackO from the sysadmin fixed server role.

EXEC sp_dropsrvrolemember 'JackO', 'sysadmin'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft