Component Integration Services only Drops the definition of a remote login previously defined by sp_addexternlogin.
sp_dropexternlogin remote_server [, login_name] [, role_name]
is the name of the remote server from which the local server is dropping account access. The remote_server is known to the local server by an entry in the master.dbo.sysservers table.
is a login account known to the local server. If login_name is not specified, the current account is used. login_name must exist in the master.dbo.syslogins table.
is the Adaptive Server user’s assigned role.
Drops the definition of an external login to the remote server CIS1012 from “bobj”. Only the “bobj” account and the “sa” account can add or modify a remote login for “bobj”:
sp_dropexternlogin CIS1012, bobj
Drops the definition of an external login to the remote server SSB from users with the sa_role:
sp_dropexternlogin SSB, NULL, sa_role
sp_dropexternlogin drops the definition of a remote login previously defined to the local server by sp_addexternlogin.
You cannot execute sp_dropexternlogin from within a transaction.
The remote_server must be defined to the local server by sp_addserver.
To add and drop local server users, use the system procedures sp_addalias and sp_droplogin.
Only login_name or a System Administrator can execute sp_dropexternlogin.
System procedures sp_addexternlogin, sp_helpexternlogin, sp_addlogin, sp_droplogin
