Find Database Dependencies in Jobs and other databases

  • 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?

  • 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.

  • Thanks, that would be great.

  • 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.

  • Is this already submitted or I can still do it?

    Thanks,
    AMAR
    amarreddy23@gmail.com

  • 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.

  • 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.

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

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

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