Dependencies of an object

[Pauldohert]

I am trying to find all the objects that depend on object x.


Have tried sp_Depend 'x' but that seems to bring only the objcets x d[ends on.


I am looking now at the sysdepends table , but I'm not getting very far with waht the data all means.


Can anyone point me in the right direction.

 

[pdx_man]

Here is a quick hint. If you don't know what to do from here, let me know. Gotta run.

select object_name(id),id, object_name(depid),depid from sysdepends

 

[Pauldohert]

Cheers - I'll give that a go.

(I apologise for the double post on this subject - I don't know how that happened, must have backed thru the browser and posted again by accident)