sp_helpremotelogin (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Reports information about remote logins for a particular remote server, or for all remote servers, defined on the local server.

System_CAPS_ICON_important.jpg Important


This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use linked servers and linked server stored procedures instead.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

  
sp_helpremotelogin [ [ @remoteserver = ] 'remoteserver' ]   
     [ , [ @remotename = ] 'remote_name' ]  

[ @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.

0 (success) or 1 (failure)

Column nameData typeDescription
serversysnameName of a remote server defined on the local server.
local_user_namesysnameLogin on the local server that remote logins from server map to.
remote_user_namesysnameLogin on the remote server that maps to local_user_name.
optionssysnameTrusted = 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.

No permissions are checked.

A. Reporting help on a single server

The following example displays information about all remote users on the remote server Accounts.

EXEC sp_helpremotelogin 'Accounts';  

B. Reporting help on all remote users

The following example displays information about all remote users on all remote servers known to the local server.

EXEC sp_helpremotelogin;  

sp_addremotelogin (Transact-SQL)
sp_dropremotelogin (Transact-SQL)
sp_helpserver (Transact-SQL)
sp_remoteoption (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show: