Post reply

Who is using my linked server ?

  • May 22, 2012 at 4:51 am

    #256161

    Does anybody know of a nice way to see if a particular linked server is being used by a view/job/procedure ?

    One method would be to change the user logon in the linked server and see what jobs fail. But I am searching a more graceful way 🙂

  • May 22, 2012 at 4:54 am

    #1490973

    you could query the definition of the object in sys.sql_module in the databases and then query sysjobsteps in msdb where the definition or job step is like the linked server name

    select * from sys.sql_modules where definition like '%%'

    select * from msdb.dbo.sysjobsteps where command like '%%' and subsystem = 'TSQL'

  • May 22, 2012 at 5:06 am

    #1490978

    Thanks, I think that did the trick 🙂

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

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