sp-linkedservers-transact-sql.md

title	sp_linkedservers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
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
caps.latest.revision	28
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sp_linkedservers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

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)