Taking DB offline, want to see dependancies

  • I have been assigned to take a DB offline. But before I do I am supposed to check to see what other DB's, Queries, functions, etc.. use that DB.

    If I view dependancy info, it doesn't go across all the instances on that box.

    How can I see which of my other DB's have calls to that DB?

  • I would run a trace on that database and see whats going on in that database, hope this helps 🙂

  • You'd have to search code in other dbs for the 3 or 4 part naming against that db. There isn't anything tracking this as a db should be a self-contained unit.

  • Thanks guys, I ended up using this on every DB - (in case someone else needs it)

    SELECT routine_name, routine_type FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%cam%'

    go

    SELECT routine_name, routine_type FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%aum%'

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

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