| title | sys.linked_logins (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | af57bf0c-a265-410f-9bab-63b78569b4a6 | ||||
| author | VanMSFT | ||||
| ms.author | vanto |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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)