TechNet
Export (0) Print
Expand All

sp_linkedservers (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

  
sp_linkedservers  

0 (success) or a nonzero number (failure)

Column nameData typeDescription
SRV_NAMEsysnameName of the linked server.
SRV_PROVIDERNAMEnvarchar(128)Friendly name of the OLE DB provider managing access to the specified linked server.
SRV_PRODUCTnvarchar(128)Product name of the linked server.
SRV_DATASOURCEnvarchar(4000)OLE DB data source property corresponding to the specified linked server.
SRV_PROVIDERSTRINGnvarchar(4000)OLE DB provider string property corresponding to the linked server.
SRV_LOCATIONnvarchar(4000)OLE DB location property corresponding to the specified linked server.
SRV_CATsysnameOLE DB catalog property corresponding to the specified linked server.

Requires SELECT permission on the schema.

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)

Community Additions

ADD
Show:
© 2016 Microsoft