MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for SQL Server


 

LINKEDSERVERS Rowset (OLE DB)

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

The LINKEDSERVERS rowset contains the columns described in the following table.

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.