Andy Brownsword takes another look:
Last week we looked at identifying object dependencies through performing a wildcard search on the objects such as procedures. I noted another option could be to use the views such as
sys.sql_expression_dependencies
and Kevin also commented about using the supporting functions such assys.dm_sql_referencing_entities
.I wanted to briefly look at both of these options and look at how their results can differ.
Linkception graf achieved.