Reports information about a particular remote server’s logins or about all remote server logins.
sp_helpremotelogin [remoteserver[, remotename]]
is the name of the server about which to report remote login information.
is the name of a particular remote user on the remote server.
Displays information about all the remote users of the remote server GATEWAY:
sp_helpremotelogin GATEWAY
Displays information about all the remote users of all the remote servers known to the local server:
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:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_addremotelogin, sp_dropremotelogin, sp_helpserver
