How to: Rename a Stored Procedure (SQL Server Management Studio)

New: 5 December 2005

This topic describes how to rename a stored procedure by using Object Explorer in SQL Server Management Studio.

Changing the name or definition of a stored procedure can cause dependent objects to fail when the objects are not updated to reflect the changes that have been made to the stored procedure. For more information, see How to: View the Dependencies of a Stored Procedure (SQL Server Management Studio).

  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. Determine the dependencies of the stored procedure.

  4. Expand Stored Procedures, right-click the procedure to rename, and then click Rename.

  5. Modify the stored procedure name.

  6. Modify the stored procedure name referenced in dependent objects or scripts.