Note
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o magpalit ng mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
Applies to: 
SQL Server
Removes a SQL Server login, which prevents access to an instance of SQL Server under that login name.
Important
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use DROP LOGIN instead.
Transact-SQL syntax conventions
Syntax
sp_droplogin [ @loginame = ] N'loginame'
[ ; ]
Arguments
[ @loginame = ] N'loginame'
The login to be removed. @loginame is sysname, with no default. @loginame must already exist in SQL Server.
Return code values
0 (success) or 1 (failure).
Remarks
sp_droplogin calls DROP LOGIN.
sp_droplogin can't be executed within a user-defined transaction.
Permissions
Requires ALTER ANY LOGIN permission on the server.
Examples
The following example uses DROP LOGIN to remove the login Victoria from an instance of SQL Server. This method is preferred.
DROP LOGIN Victoria;
GO