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.
