1 Version 4.0 -- 1/15/89 sp_dropremotelogin
______________________________________________________________________
NAME: sp_dropremotelogin
FUNCTION:
Drops a remote user login by deleting his or her entry in
master.dbo.sysremotelogins.
SYNTAX:
sp_dropremotelogin remoteserver [,[,loginame] remotename]
EXAMPLES:
1) sp_dropremotelogin gateway
sp_dropremotelogin Version 4.0 -- 1/15/89 2
______________________________________________________________________
Drops the default-name entry for the remote server gateway.
2) sp_dropremotelogin gateway, churchy
Drops the default-name entry for mapping remote logins from gate-
way to the local user churchy.
3) sp_dropremotelogin gateway, churchy, pogo
Drops the remote login entry for the remote user pogo from the
remote server gateway that gets mapped to the local user churchy.
PARAMETERS:
remote - is the name of the server which has the remote login to
be dropped.
loginame - is the local server's user name that is associated
with the remote server in sysremotelogins.
3 Version 4.0 -- 1/15/89 sp_dropremotelogin
______________________________________________________________________
remotename - is the remote user name that gets mapped to
loginame when logging in from the remote server.
COMMENTS:
o Executing sp_dropremotelogin drops a user login from a remote
server, deleting the user's entry from
master.dbo.sysremotelogins.
o For a more complete discussion of remote logins, please see
sp_addremotelogin.
o To add and drop local server users, use the stored procedures
sp_addlogin and sp_droplogin.
MESSAGES:
The remote user's entry in master.dbo.sysremotelogins has been
deleted. The remote user no longer has access to this
server.
sp_dropremotelogin Version 4.0 -- 1/15/89 4
______________________________________________________________________
loginame from the remote server remoteserver.
The specified remote login name does not exist for the named
server.
PERMISSIONS:
Execute permission to System Administrator.
TABLES USED:
master.dbo.sysremotelogins, master.dbo.sysservers
SEE ALSO:
sp_addremotelogin, sp_helpremotelogin, sp_addserver,
sp_helpserver, sp_addlogin,