| title | LINKEDSERVERS Rowset (OLE DB) | ||
|---|---|---|---|
| description | The LINKEDSERVERS rowset enumerates organization data sources that can participate in distributed queries in OLE DB Driver for SQL Server. | ||
| author | David-Engel | ||
| ms.author | davidengel | ||
| ms.date | 06/12/2018 | ||
| ms.service | sql | ||
| ms.subservice | connectivity | ||
| ms.topic | reference | ||
| ms.custom |
|
||
| helpviewer_keywords |
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
[!INCLUDEDriver_OLEDB_Download]
The LINKEDSERVERS rowset enumerates organization data sources that can participate in [!INCLUDEssNoVersion] 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.