sys.sp_helpremotelogin

Description

Reports information about remote logins for a particular remote server, or for all remote servers, defined on the local server. Specifies the remote server about which the remote login information is returned. about all remote servers defined on the local server is returned. A specific remote login on the remote server.

Syntax

sp_helpremotelogin
[ [ @remoteserver = ]
N
'remoteserver'
]
[ , [ @remotename = ]
N
'remotename'
]
[ ; ]