Reports information about remote logins for a particular remote server, or for all remote servers, defined on the local server.
sp_helpremotelogin [[@remoteserver =] 'remoteserver']
[,[@remotename =] 'remote_name']
0 (success) or 1 (failure)
| 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. |
Use sp_helpserver to list the names of remote servers defined on the local server.
Execute permissions default to the public role.
This example displays information about all remote users on the remote server Accounts.
EXEC sp_helpremotelogin 'Accounts'
This example displays information about all remote users on all remote servers known to the local server.
EXEC sp_helpremotelogin
| sp_addremotelogin | sp_remoteoption |
| sp_dropremotelogin | System Stored Procedures |
| sp_helpserver |