The LINKEDSERVERS 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 | The name of a linked server. |
| SVR_PRODUCT | DBTYPE_WSTR | The manufacturer or other name identifying the type of data store represented by the name of the linked server. |
| SVR_ PROVIDERNAME |
DBTYPE_WSTR | The friendly name of the OLE DB provider used to consume data from the server. |
| SVR_DATASOURCE | DBTYPE_WSTR | An OLE DB DBPROP_INIT_ DATASOURCE string used to acquire a data source from the provider. |
| SVR_ PROVIDERSTRING |
DBTYPE_WSTR | An OLE DB DBPROP_INIT_ PROVIDERSTRING value used to acquire a data source from the provider. |
| SVR_LOCATION | DBTYPE_WSTR | An OLE DB DBPROP_INIT_ LOCATION string used to acquire a data source from the provider. |