ApexSQL Clean : Impact Analysis Tool
December 29, 2006[From SQL-Server-Performance.com]
Apex SQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures. Apex SQL Clean includes a powerful visual Dependency viewer that converts database dependies into a graphical display.
The article continues at http://www.sql-server-performance.com/software_spotlights/fk_apex_clean.asp