You're looking for the table-valued functions sys.dm_sql_referenced_entities()
and sys.dm_sql_referencing_entities()
. These will not show cross database dependencies. You may also want to look at Redgate's SQL Dependency Tracker 3.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA