• Disclaimer: I do NOT work for Redgate

    Your easiest bet might be to invest in SQL dependency checker (yes - it's from RedGate, the parent company for this very site). It's a much cleaner interface to get to what dependencies (i.e. who's calling who) on a cross-database setting. Using the data in SQL's internal dependency checking was not as reliable; even when the dta is accurate, it doesn't give you the nice visualization tool to see and track down the links you need to adjust.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?