How to view the dependencies of a stored procedure (Enterprise Manager)

To view the dependencies of a stored procedure

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, expand the database in which the stored procedure belongs, and then click Stored Procedures.
   
   
3. In the details pane, right-click the stored procedure, point to All Tasks, and then click Display Dependencies.

See Also

Viewing a Stored Procedure