Component Integration Services only Reports information about external login names.
sp_helpexternlogin [remote_server] [, login_name] [, role_name]
is the name of the remote server that has been added to the local server with sp_addserver.
is a login account on the local server.
is the Adaptive Server user’s assigned role.
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.
System procedures sp_addexternlogin, sp_addlogin, sp_addserver, sp_dropexternlogin, sp_helpserver
