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