To find the dependency of objects across multiple databases?

Question

How can you find the dependencies of a table across databases?

Normally sp_depends will provide information for all dependent objects on a particular objects, or through a GUI tool you can see it in a more structured way. Now dependencies shown by these methods are limited to a single database - what if we have dependents in other databases?

Is there any query to do it?

Answer 1

AFAIK, SQL Server can't do this out of the box.

You'll most likely need a third-party program like Red-Gate's SQL Dependency Tracker which is supposed to do this.