Connecting Tech Pros Worldwide Forums | Help | Site Map

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

Newbie
 
Join Date: Nov 2008
Posts: 8
#1: Jan 3 '09
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?

Reply