Drop all stored procedures in database

dropSP.sql

-- first drop function
declare @procName varchar(500)
declare cur cursor 

for select [name] from sys.objects where type = 'p'
open cur
fetch next from cur into @procName
while @@fetch_status = 0
begin
    exec('drop procedure ' + @procName)
    fetch next from cur into @procName
end
close cur
deallocate cur


-- second drop function
-- this function generates list of DROP PROCEDURE statements
-- copy the results, open new query then paste and run.
SELECT 'DROP PROCEDURE ' + p.NAME
FROM sys.procedures p