How to rename all stored procedure in SQL SERVER

To rename a Stored procedure in Sql Server, use the following command

EXEC sp_rename 'Current_sp_name' 'New_sp_name';

To prefix a string value to all stored procedure in a database, execute the following command. Then copy the result, past it in a new window and execute it. This query returns all stored procedures. If you don't wish to add some of the procedures , please use 'where' statement to avoid those procedures ( like SqlMembeshipProvider stored procedures).

Please check everything before you run.

SELECT 'EXEC sp_rename '+ ''''+s.NAME+ '.' + p.NAME+''','''+s.NAME+ '.' +'your_suffix'+p.NAME+''''
FROM SYS.PROCEDURES p ,SYS.SCHEMAS s
WHERE p.schema_id = s.schema_id

Alternate Titles: rename a Stored procedure in Sql Server, prefix a string to all Stored procedures in Sql Server, suffix string to all Stored procedures in Sql Server