1 Version 4.0 -- 1/15/89 sp_droplogin
______________________________________________________________________
NAME: sp_droplogin
FUNCTION:
Drops a SQL Server user by deleting his or her entry in
master.dbo.syslogins.
SYNTAX:
sp_droplogin loginame
EXAMPLES:
sp_droplogin victoria
sp_droplogin Version 4.0 -- 1/15/89 2
______________________________________________________________________
Victoria has been dropped from SQL Server.
PARAMETERS:
loginame - is the name of the user as listed in
master.dbo.syslogins.
COMMENTS:
o Executing sp_droplogin drops a user login from SQL Server,
deleting the user's entry from master.dbo.syslogins.
o The sp_droplogin procedure checks the current database (but no
others) to see if the login to be dropped is a user there. You
cannot execute sp_droplogin if the user exists in the current
database.
MESSAGES:
The user's entry in master.dbo.syslogins has been deleted. The
3 Version 4.0 -- 1/15/89 sp_droplogin
______________________________________________________________________
user no longer has access to SQL Server.
The specified login name does not exist.
Only the System Administrator can add or drop logins. You aren't
the System Administrator.
The specified login name is a user in the current database. Drop
the user from the current database with the sp_dropuser pro-
cedure. When this error message is generated, the database
name, user's login name, and user's name in the database are
displayed.
PERMISSIONS:
Execute permission to System Administrator.
TABLES USED:
sysusers, master.dbo.syslogins
SEE ALSO:
sp_droplogin Version 4.0 -- 1/15/89 4
______________________________________________________________________
sp_addlogin, sp_changedbowner, sp_dropuser, sp_helpuser