sp_dropremotelogin

Drops a remote user login.

sp_dropremotelogin remoteserver [, loginame [, remotename] ]

remoteserver: is the name of the server that has the remote login to be dropped.

loginame: is the local server’s user name that is associated with the remote server in the sysremotelogins table.

remotename: 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.

The permission checks for sp_dropremotelogin differ based on your granular permissions settings.

Granular permissions enabled	With granular permissions enabled, you must be a user with manage any remote login privilege.
Granular permissions disabled	With granular permissions disabled, you must be a user with sa_role.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect