Pages

Tuesday, August 14, 2012

find the linked servers created in the instance of SQL Server

How to find the number of linked servers created in the instance of SQL Server

Query which gives the number of linked servers created:

select * from sys.servers where is_linked=1

Note: Output will also have the link servers created by replication when it was setup.

Hope the above information helps

Thanks