select * from sys.dm_sql_referenced_entities (<ENTITY>, 'object')
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:
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment