Export (0) Print
Expand All

sp_linkedservers (Transact-SQL)

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 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.

Requires SELECT permission on the schema.

Community Additions

ADD
Show:
© 2014 Microsoft