Wednesday, November 14, 2012

Getting an accurate list of dependencies from SSMS

The dependency dialog in SQL Server Management Studio does not appear to be particularly reliable, not returning some dependencies. The solution is to use the sys.dm_sql_referenced_entities table function:
select * from sys.dm_sql_referenced_entities (<ENTITY>, 'object')

0 comments:

Post a Comment