SQL Server Administration - User/Login Admin

Drop Login from Server Role

Drops a login from a Server Role.

Syntax - SQL Server 2005/2008

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

--returns 0=ok 1=failed

Example - SQL Server 2005/2008

EXEC sp_dropsrvrolemember 'ericm', 'sysadmin'
GO

 Collapse All    Expand All
Custom Search

SQL Server Information and Resources