sys.remote_logins (Transact-SQL)

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

Returns a row per remote-login mapping. This catalog view is used to map incoming local logins that claim to be coming from a corresponding server to an actual local login.

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

Column name Data type Description
server_id int ID of the server in sys.servers. This name is supplied by the connection from the "remote" server.
remote_name sysname Login name that the connection will supply to be mapped. If NULL, the login name that is specified in the connection is used.
local_principal_id int ID of the server principal to whom the login is mapped. If 0, the remote login is mapped to the login with the same name.
modify_date datetime Date the linked login was last changed.

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Linked Servers Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)