Chapter 1: System Procedures

sp_helpexternlogin

Component Integration Services only Reports information about external login names.

sp_helpexternlogin   [  server  [,  loginame  [,  rolename  ]  ]  ]

server: is the name of the remote server that has been added to the local server with sp_addserver.

Displays all remote servers, local login names, role names, and external logins:

sp_helpexternlogin

Displays local login names, role names, and external logins for the server named SSB:

sp_helpexternlogin SSB

Displays remote servers, local login names and external logins for the user named “milo”:

sp_helpexternlogin NULL, milo

Displays external logins for remote server SSB where the local user name is “trixi”:

sp_helpexternlogin SSB, trixi

Displays external logins for remote server SSB for local users with sa_role:

sp_helpexternlogin SSB, NULL, sa_role

sp_helpexternlogin displays all remote servers, the user’s local login name, role name, and the user’s external login name.
Add remote servers with sp_addserver. Add local logins with sp_addlogin.

Any user can execute sp_helpexternlogin.

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