sp-linkedservers-transact-sql.md

title	sp_linkedservers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_linkedservers sp_linkedservers_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_linkedservers
ms.assetid	d8f82f78-8a1f-4831-bcee-7c36c6e7dfbb
author	stevestein
ms.author	sstein

sp_linkedservers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Returns the list of linked servers defined in the local server.

Transact-SQL Syntax Conventions

Syntax

  
sp_linkedservers  

Return Code Values

0 (success) or a nonzero number (failure)

Result Sets

Column name	Data type	Description
SRV_NAME	sysname	Name of the linked server.
SRV_PROVIDERNAME	nvarchar(128)	Friendly name of the OLE DB provider managing access to the specified linked server.
SRV_PRODUCT	nvarchar(128)	Product name of the linked server.
SRV_DATASOURCE	nvarchar(4000)	OLE DB data source property corresponding to the specified linked server.
SRV_PROVIDERSTRING	nvarchar(4000)	OLE DB provider string property corresponding to the linked server.
SRV_LOCATION	nvarchar(4000)	OLE DB location property corresponding to the specified linked server.
SRV_CAT	sysname	OLE DB catalog property corresponding to the specified linked server.

Permissions

Requires SELECT permission on the schema.

See Also

sp_catalogs (Transact-SQL)
sp_column_privileges (Transact-SQL)
sp_columns_ex (Transact-SQL)
sp_foreignkeys (Transact-SQL)
sp_indexes (Transact-SQL)
sp_primarykeys (Transact-SQL)
sp_table_privileges (Transact-SQL)
sp_tables_ex (Transact-SQL)
System Stored Procedures (Transact-SQL)
Distributed Queries Stored Procedures (Transact-SQL)