SQL Drop All Stored Procedures from Database

DECLARE @SPName varchar(128)
DECLARE @Command varchar(256)

DECLARE SP_Cursor CURSOR SCROLL STATIC READ_ONLY FOR
SELECT SPECIFIC_NAME FROM INFORMATION_SCHEMA.ROUTINES

OPEN SP_Cursor

FETCH NEXT FROM SP_Cursor INTO @SPName

WHILE (@@FETCH_STATUS = 0) BEGIN

-- Use DROP FUNCTION for User-Defined Functions

SET @Command = 'DROP PROCEDURE ' + @SPName

EXEC (@Command)

FETCH NEXT FROM SP_Cursor INTO @SPName

END

CLOSE SP_Cursor
DEALLOCATE SP_Cursor

Read more...