How to get list of all the linked servers?

On 16 Apr, 2015

MS SQL DBA

By : Charith Silva

No Comments

There are several methods to get the details of linked servers in SQL Server instance. Following simple script can be used to get list of linked servers in current SQL Server instance. This information also can be pulled using SQL Server Management Studio.

USE [master];
GO

SELECT @@SERVERNAME AS ServerName ,
Server_Id AS LinkedServerID ,
name AS LinkedServerName ,
Product ,
Provider ,
Data_Source ,
Modify_Date
FROM sys.servers
ORDER BY Server_Id

USE [master];

SELECT @@SERVERNAME AS ServerName ,

Server_Id AS LinkedServerID ,

name AS LinkedServerName ,

Product ,

Provider ,

Data_Source ,

Modify_Date

FROM sys.servers

ORDER BY Server_Id

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva