May 22, 2012 at 4:51 am
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy