Drops a remote user login.
sp_dropremotelogin remoteserver [, loginame [, remotename] ]
is the name of the server that has the remote login to be dropped.
is the local server’s user name that is associated with the remote server in the sysremotelogins table.
is the remote user name that gets mapped to loginame when logging in from the remote server.
Drops the entry for the remote server named GATEWAY:
sp_dropremotelogin GATEWAY
Drops the entry for mapping remote logins from the remote server GATEWAY to the local user named “churchy”:
sp_dropremotelogin GATEWAY, churchy
Drops the login for the remote user “pogo” on the remote server GATEWAY that was mapped to the local user named “churchy”:
sp_dropremotelogin GATEWAY, churchy, pogo
Executing sp_dropremotelogin drops a user login from a remote server, deleting the user’s entry from master.dbo.sysremotelogins.
For a more complete discussion on remote logins, see sp_addremotelogin.
To add and drop local server users, use the system procedures sp_addlogin and sp_droplogin.
Only a System Administrator can execute sp_dropremotelogin.
System procedures sp_addlogin, sp_addremotelogin, sp_addserver, sp_droplogin, sp_helpremotelogin, sp_helpserver
