August 25, 2009 at 9:03 am
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?
August 25, 2009 at 9:11 am
I would run a trace on that database and see whats going on in that database, hope this helps 🙂
August 25, 2009 at 9:16 am
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.
August 25, 2009 at 9:48 am
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