Linked Server

I was looking for a linked server in SQL management studio. I can see bunch of linked server but not sure which one I needed.

I found out that following query not only list the linked server name, but also server name, database name information.

Here is the query.

SELECT * from sys.servers
WHERE is_linked = 1

Happy SQLing!!