@Gail,

This works and runs fast, but dm_sql_referencing doesn't provide the object type, which is critical.

What I'm doing is dropping tables in a database that...

Thanks Eric. This did work, only thing is the runtime is really long... I even used object_id in my WHERE clause, but the text string searching of those...

Thanks for info Eric. I think the SQL Audit trace scripting will be the route to go.