Find Database Dependencies in Jobs and other databases

Question

Find Database Dependencies in Jobs and other databases

Steve Jones - SSC Editor

SSC Guru

Points: 736297
More actions
January 16, 2017 at 1:12 pm

#317766

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?

Viewing 8 posts - 1 through 7 (of 7 total)

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

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 1

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.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Steve Jones - SSC Editor SSC Guru Points: 736297 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736297

January 17, 2017 at 9:37 am

#1923207

Thanks, that would be great.

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 3

Two articles submitted. I hope I did the formatting right to make your job easier.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

amarreddy23 Ten Centuries Points: 1361 More actions · Answer 4

Is this already submitted or I can still do it?

Thanks,
AMAR
amarreddy23@gmail.com

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 5

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.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 6

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.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Steve Jones - SSC Editor SSC Guru Points: 736297 More actions · Answer 7

Thanks, Brandie. Forgot to close this thread. Doing so now.