| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.remote_logins (Transact-SQL) |
sys.remote_logins (Transact-SQL) |
VanMSFT |
vanto |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
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.
| 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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Linked Servers Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)