Mahmoud ElMansy: knowledge meant to be free

Drop All Stored Procedures From Your Database SQL 2008

This code sample demonstrate how to drop all stored procedures from your Database.

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