Export (0) Print
Expand All

LINKEDSERVERS Rowset (OLE DB)

The LINKEDSERVERS rowset enumerates organization data sources that can participate in SQL Server distributed queries.

The LINKEDSERVERS rowset contains the following columns.

Column name

Type indicator

Description

SVR_NAME

DBTYPE_WSTR

Name of a linked server.

SVR_PRODUCT

DBTYPE_WSTR

Manufacturer or other name identifying the type of data store represented by the name of the linked server.

SVR_PROVIDERNAME

DBTYPE_WSTR

Friendly name of the OLE DB provider used to consume data from the server.

SVR_DATASOURCE

DBTYPE_WSTR

OLE DB DBPROP_INIT_DATASOURCE string used to acquire a data source from the provider.

SVR_PROVIDERSTRING

DBTYPE_WSTR

OLE DB DBPROP_INIT_PROVIDERSTRING value used to acquire a data source from the provider.

SVR_LOCATION

DBTYPE_WSTR

OLE DB DBPROP_INIT_LOCATION string used to acquire a data source from the provider.

The rowset is sorted on SRV_NAME and a single restriction is supported on SRV_NAME.

Community Additions

ADD
Show:
© 2014 Microsoft