SQLServerCentral

Find Database Dependencies in Jobs and other databases


https://www.sqlservercentral.com/Forums/Topic1851227.aspx

By Steve Jones - SSC Editor - Monday, January 16, 2017 6:12 AM

I'm looking for an article that will help someone determine if a job or other object depends on a database. Imagine I want to delete database, "Sales", but I'm not sure where this could cause issues. How do I search my instance?
By Brandie Tarvin - Monday, January 16, 2017 9:35 PM

Steve Jones - SSC Editor - Monday, January 16, 2017 1:12 PM
I'm looking for an article that will help someone determine if a job or other object depends on a database. Imagine I want to delete database, "Sales", but I'm not sure where this could cause issues. How do I search my instance?

Oh. I may actually have code for that. I'll see what kind of article I can come up with.
By Steve Jones - SSC Editor - Tuesday, January 17, 2017 2:37 AM

Thanks, that would be great.
By Brandie Tarvin - Friday, February 10, 2017 12:26 AM

Two articles submitted. I hope I did the formatting right to make your job easier.
By Brandie Tarvin - Monday, April 17, 2017 9:16 PM

amarreddy23 - Tuesday, April 18, 2017 1:05 AM
Is this already submitted or I can still do it?


It's already submitted and published. Two articles.
By amarreddy23 - Monday, April 17, 2017 6:05 PM

Is this already submitted or I can still do it?
By Steve Jones - SSC Editor - Tuesday, April 18, 2017 1:21 AM

Thanks, Brandie. Forgot to close this thread. Doing so now.
By Brandie Tarvin - Monday, April 17, 2017 9:19 PM

The links are here:
part 1
part 2

If you have something different or want to cover anything I missed, please feel free to submit another article. There's never enough articles on this site and different perspectives do help users.