Nick Upson wrote:

> Is there a tool that can show me a complete dependancy tree, several I have
> tried can show me the items that depend upon the current one but that can be
> very timeconsuming when trying to look after 100's of SPs that call each
> other.

If you need it just in order to get all the dependencies for some
table/view/column, you can use FlameRobin. Just open the table's
property page and click on "Generate Rebuild Script". It will generate
SQL script to first drop and later recreate all the dependent objects
and constraints.

HTH

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org