Udostępnij za pośrednictwem


sp_linkedservers (Transact-SQL)

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

Ikona łącza do tematu Transact-SQL Syntax Conventions

Składnia

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.

Zobacz także

Odwołanie

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)