rename database in sql server using stored procedure code example

Example: rename stored procedure in sql server

--Rename the stored procedure.  
EXEC sp_rename 'OldName', 'NewName';