(Component Integration Services only) Reports information about external login names.
sp_helpexternlogin [server[, loginame[, rolename]]]
sp_helpexternlogin
sp_helpexternlogin SSB
sp_helpexternlogin NULL, milo
sp_helpexternlogin SSB, trixi
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 create login.
Any user can execute sp_helpexternlogin. Permission checks do not differ based on the granular permissions settings.
Values in event and extrainfo columns from the sysaudits table are:
Information | Values |
---|---|
Event | 38 |
Audit option | exec_procedure |
Command or access audited | Execution of a procedure |
Information in extrainfo |
|