Schema Rowsets - LINKEDSERVERS Rowset
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
The LINKEDSERVERS rowset 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 | 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.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for