>I find some thing yesterday.
>
>When I used SQL Sever Enterprise Manager and go to orders tables in Northwind. Then open Show dependencies in Design table. I saw all objects depend on or are depended on Orders. It looks very good.
>
>When I used sp_depends ‘orders’, I only see some objects depend on orders not including table Order Details and didn’t see any objects are depended on Orders.
>It is different with the sp_depends description in Help.
>
Jim,

See http://www.microsoft.com/sql/techinfo/tips/development/displayingdependencies.asp for explanation.