Keeping sysdepends up to date in SQL Server 2008 Dependencies can be unreliable, and you can fill some of the gaps with a DDL trigger.