Rename Stored Procedures

Use sp_rename to rename stored procedures.

sp_rename objname, newname 

For example, to rename showall to countall:

sp_rename showall, countall 

The new name must follow the rules for identifiers. You can change the name only of stored procedures that you own. The database owner can change the name of any user’s stored procedure. The stored procedure must be in the current database.

• Rename Objects Referenced by Procedures
  If you rename any of the objects a stored procedure references, you must drop and re-create the procedure.