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.
System procedures sp_addremotelogin, sp_dropremotelogin, sp_helpserver
