Stamey, to be sure you're going to have to write all the code by hand. Define the list of objects you need to inspect (what I started to do), figure out how to look at the objects in the metadata and go after each type one by one. The dependency information in SQL Server is not reliable. This is about the best way I have seen it laid out:
There are rumors that all of this is fixed with Denali but we'll have to wait and see if they deliver. Good luck 😎
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato