Yeah, we're not big on dynamic SQL. Maybe the idea is that you usually won't be truncating a table unless you're going to do something else with it.

Thanks anyway!

Thank you all for your replies! I was able to build something using sys.dm_sql_referenced_entities to cycle through all the stored procedures and pull the referenced entities.

The only missing piece I...