Finding dependency of Objects in SQL Server 2000

Hello,

I would like to know , how can we find the objects dependency in SQL Server.

e.g If there is a Stored Procedure (sp_GetShowEmp) , I need to find On which tables,views,Stored Procedures,Functions is dependent. And Name of the other objects which are dependent on the Stored Procedure (sp_GetShowEmp).

Thanks

Sidheshwar

You can take help of SP_DEPENDS in this case to show the dependancy of other objects on a table or trigger or view.