I have 20 Databases in my production Server and the tables in some database are used by the Views , functions and procedures of some Other Databases. Now I want to find out the Dependencies of the Tables and their Database Location. I can use the following Dynamic SQL to get the SQL statements and then execute them.
Eg:
If I want to find out the List of Procedures and Views on all the Databases that are using the table called Col1
Dependencies Across Databases
