SQLLinkedServers returns a list of data sources that can participate in distributed queries.
SQL Server linked servers are OLE DB data sources that can be referenced using four-part names in distributed queries. SQLLinkedServers returns the properties defining the data source as a result set. Linked servers are defined to SQL Server using the sp_addlinkedserver system stored procedure. The columns of the result set are defined as follows.
Name of the linked server.
Friendly name of the OLE DB provider for this linked server.
Product name for this linked server.
Name that identifies the source of the data to this provider.
Provider-specific string that identifies the source of the data.
Location argument that identifies the database to this provider.
Name of the catalog containing the data on the linked server.
SRV_PROVIDERSTRING is NULL when the SRV_DATASOURCE and SRV_CAT information is sufficient to identify the source of the data to the provider.
When the linked server is a server running an instance of SQL Server, SRV_DATASOURCE is the name of the server, SRV_CATALOG is the name of the database, and SRV_LOCATION is NULL.