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.

Did I do something wrong?

Thanks


Jim