To find the dependence of objects on multiple databases?

Question

How can you find table dependencies between databases?

It sp_dependswill usually provide information about all dependent objects for specific objects or through a GUI tool, which you can see in a more structured way. Now the dependencies shown by these methods are limited to one database — what if we have dependents in other databases?

Is there any query for this?

Answer 1

AFAIK, SQL Server cannot do this out of the box.

, , , Red-Gate SQL Dependency Tracker, .

Answer 2

db- - , , , sp_depends. , . , , . Microsoft " " sys.dm_sql_referencing_entities "" sys.dm_sql_referenced_entities ". sp_depends , . , : ProcA ProcB. ProcB ProcA. ProcA THEN, ProcB sp_depends , - , ProcB, THEN ProcA sp_depends .

, , , , , , , db, , Visual Studio for Database . , , , , , dbs .

db GUI ApexSql . , , .