Rename Stored Procedure Syntax:

sp_rename 'old_procedure_name', 'new_procedure_name'

Rename Stored Procedure Example:

EXEC sp_rename 'SalesByCustomer', 'NewSalesByCustomer';
GO