Share via


How to: View the Dependencies of a Stored Procedure (SQL Server Management Studio)

New: 5 December 2005

This topic describes how to view the dependencies of a stored procedure by using Object Explorer in SQL Server Management Studio.

Before you modify, rename, or delete a stored procedure, it is important to know what objects depend on the stored procedure. For example, changing the name or definition of a stored procedure can cause dependent objects to fail if the dependent objects are not updated to reflect the changes that have been made to the stored procedure.

To view the dependencies of a stored procedure

  1. In Object Explorer, connect to an instance of SQL Server 2005 Database Engine, and then expand that instance.

  2. Expand Databases, expand the database in which the stored procedure belongs, and then expand Programmability.

  3. Expand Stored Procedures, right-click the procedure, and then click View Dependencies.

  4. View the list of objects that depend on the stored procedure.

  5. View the list of objects on which the stored procedure depends.

  6. Click OK.

See Also

Tasks

How to: Use Templates in SQL Server Management Studio
How to: Create a Stored Procedure (SQL Server Management Studio)
How to: Modify a Stored Procedure (SQL Server Management Studio)
How to: Delete a Stored Procedure (SQL Server Management Studio)
How to: Rename a Stored Procedure (SQL Server Management Studio)

Other Resources

Stored Procedure How-to Topics

Help and Information

Getting SQL Server 2005 Assistance