Post reply

How to find whether a server/databse is used as linked server?

  • May 16, 2011 at 4:08 am

    #240337

    Hi

    Is there a way to findout whether a particular sql server/database is used as linked server in other sql server?

    Thanks,

    Giri

  • May 16, 2011 at 9:26 am

    #1325184

    On a server you can query sys.servers to see remote servers registered. That doesn't tell you where ServerA is being used, but it can tell you if you are on ServerB, if ServerA is registered

    http://msdn.microsoft.com/en-us/library/ms178530.aspx

  • May 16, 2011 at 7:43 pm

    #1325551

    Or, lazy folks like me in SSMS could expand the Object Explorer, look under Server Objects and Linked Servers and see if your server is listed there.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply