SQL Server Administration - User/Login Admin

Drop Login

Drop a SQL Server login.

Syntax - SQL Server 2005/2008

sp_droplogin [ @loginame = ] 'login'

--returns 0=ok 1=failed

Example - SQL Server 2005/2008

DROP LOGIN ericm;
GO
 Collapse All    Expand All
Custom Search

SQL Server Information and Resources