• It's worth noting that pre-2008 the dependencies catalogue might not list all the dependencies.

    Dependencies were tracked by object id, so if you create the objects out of order, or drop and recreate a dependency then the system looses track of that dependency.

    http://msdn.microsoft.com/en-us/library/ms345449(SQL.90).aspx

    This has since changed in sql server 2008

    http://msdn.microsoft.com/en-us/library/ms345449.aspx

    * edited - fixed urls