sp_linkedservers

Transact-SQL Reference

Transact-SQL Reference

sp_linkedservers

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

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.

See Also

sp_catalogs

sp_column_privileges

sp_columns_ex

sp_foreignkeys

sp_indexes

sp_primarykeys

sp_table_privileges

sp_tables_ex

System Stored Procedures