Reports information about a particular remote server’s logins or about all remote server logins.
sp_helpremotelogin [remoteserver[, remotename]]
sp_helpremotelogin GATEWAY
sp_helpremotelogin
sp_helpremotelogin reports on the remote logins for the specified server, when remoteserver is given, or on all servers, when no parameter is supplied.
Any user can execute sp_helpremotelogin. 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 |
|