Export (0) Print
Expand All

LINKEDSERVERS Rowset (OLE DB)

SQL Server 2000

The LINKEDSERVERS rowset enumerates organization data sources that can participate in Microsoft® SQL Server™ 2000 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.

Show:
© 2014 Microsoft