Get Linked Server Information In SQL Server 2008

In this article I will demonstrate about how to get linked server information.
  • 2114

In this article I will demonstrate about how to get linked server information. Using sys.servers system table we can view linked servers that are defined on a SQL Server instance.

Example

To view linked server information, run following code snipplet:

SELECT name, product,provider,query_timeout

FROM sys.servers

Output:

 sysServers.jpg

Working

All information related to linked servers defined on your SQL Server Instance can be retrieved from sys.servers system catalog view. We can get product, provider, data_source, location, provider_string, catalog etc from sys.servers system catalog view.

© 2019 DotNetHeaven. All rights reserved.