Post reply

Are my Linked Servers utilized?

  • November 21, 2007 at 9:02 am

    #70452

    Hi All,

    I am trying to clean up some legacy systems, SQL Server 2000.

    There are several Linked Servers that still function, but no one is sure if they're used.

    Is there a way to audit them and see if they are being utilized? I hate to just drop them and break something... :pinch:

    Thanks!

    [font="Verdana"]-- Wally
    -- Reluctant DBA[/font]

  • November 22, 2007 at 2:26 am

    #753333

    The fast suggestion which came to my mind:

    1. Find out the procedures which uses linked servers. I hope your users uses procedures only, they are not allowed to write their own scripts. There are such kind of procedures which search any text in sql server database objects

    2. Make an audit(i.e. with profiler) on these procedures in order to know whether they are used or not

    Regards,

    Vidas

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

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