sp_helpremotelogin
Reports information about remote logins for a particular remote server, or for all remote servers, defined on the local server.
Syntax
sp_helpremotelogin [ [ @remoteserver = ] 'remoteserver' ]
[ , [ @remotename = ] 'remote_name' ]
Arguments
[@remoteserver =] 'remoteserver'
Is the remote server about which the remote login information is returned. remoteserver is sysname, with a default of NULL. If remoteserver is not specified, information about all remote servers defined on the local server is returned.
[@remotename =] 'remote_name'
Is a specific remote login on the remote server. remote_name is sysname, with a default of NULL. If remote_name is not specified, information about all remote users defined for remoteserver is returned.
Return Code Values
0 (success) or 1 (failure)
Result Sets
| Column name | Data type | Description |
|---|---|---|
| server | sysname | Name of a remote server defined on the local server. |
| local_user_name | sysname | Login on the local server that remote logins from server map to. |
| remote_user_name | sysname | Login on the remote server that maps to local_user_name. |
| options | sysname | Trusted = The remote login does not need to supply a password when connecting to the local server from the remote server.
Untrusted (or blank) = The remote login is prompted for a password when connecting to the local server from the remote server. |
Remarks
Use sp_helpserver to list the names of remote servers defined on the local server.
Permissions
Execute permissions default to the public role.
Examples
A. Report help on a single server
This example displays information about all remote users on the remote server Accounts.
EXEC sp_helpremotelogin 'Accounts'
B. Report help on all remote users
This example displays information about all remote users on all remote servers known to the local server.
EXEC sp_helpremotelogin