Remove all User-defined Stored Procedures

 

 -- drop all user defined stored procedures

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