title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.linked_logins (Transact-SQL) |
sys.linked_logins (Transact-SQL) |
VanMSFT |
vanto |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDESQL Server Azure SQL Managed Instance]
Returns a row per linked-server-login mapping, for use by RPC and distributed queries from local server to the corresponding linked server.
Column name | Data type | Description |
---|---|---|
server_id | int | ID of the server in sys.servers. |
local_principal_id | int | Server-principal to whom mapping applies. 0 = wildcard or public. |
uses_self_credential | bit | If 1, mapping indicates session should use its own credentials; otherwise, 0 indicates that session uses the name and password that are supplied. |
remote_name | sysname | Remote user name to use when connecting. Password is also stored, but not exposed in catalog view interfaces. |
modify_date | datetime | Date the linked login was last changed. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Catalog Views (Transact-SQL)
Linked Servers Catalog Views (Transact-SQL)