finding dependencies

I think that anyone who has used the system stored procedure sp_depends to find dependencies in SQL Server will have discovered  that the results cannot always be relied upon.  Most notably, this can occur when modules (procedures, views etc) have been created out of dependency order.  It seems that SQL Server only populates sys.depends values [...]