This procedure shows in a tree structure the dependencies of an object. It's very a basic, but effective script. Script is developed for 2K5
Make sure recursive triggers is enabled!
Also, in order to be sure the metadata in sys.sql_dependencies is actual, run sp_refreshview for views, or sp_refreshsqlmodule for each view/procedure and function