Creating Understanding and Educating Programmers, Developers and Technical Communities, one post at a time.

Thursday, February 24, 2011

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!!

No comments:

Post a Comment