Showing posts with label Stored Procedures. Show all posts
Showing posts with label Stored Procedures. Show all posts

SQL SERVER : Rename all stored procedures in database

I was working on a project and got a requirement from client to rename all stored procedures with  some a specific work as prefix.

I referred some websites and finally found following command,
It renames all stored procedures as single execution.

How To : Drop all stored procedures from a database

Ever faced such a condition where you need to remove all stored procedures from your Database?
If you have to do the same, what will you do?  I am sure you will Google :)

I have got a link at MattBerther where you can find a script that helps you to remove all stored procedures from selected database.
Here is the copy of that script: