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 nameType indicatorDescription
SVR_NAMEDBTYPE_WSTRName of a linked server.
SVR_PRODUCTDBTYPE_WSTRManufacturer or other name identifying the type of data store represented by the name of the linked server.
SVR_PROVIDERNAMEDBTYPE_WSTRFriendly name of the OLE DB provider used to consume data from the server.
SVR_DATASOURCEDBTYPE_WSTROLE DB DBPROP_INIT_DATASOURCE string used to acquire a data source from the provider.
SVR_PROVIDERSTRINGDBTYPE_WSTROLE DB DBPROP_INIT_PROVIDERSTRING value used to acquire a data source from the provider.
SVR_LOCATIONDBTYPE_WSTROLE 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.

Schema Rowset Support (OLE DB)

Show: