If error occurs while dropping all stored procedure from sql server

create a stored procedure as follows and execute the procedure

create Procedure DeleteAllProcedures1
As
      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

           if @procName <> 'DeleteAllProcedures'

                  exec('drop procedure ' + @procName)

                  fetch next from cur into @procName

      end
      close cur
      deallocate cur
Go

      Grant Execute On dbo.DeleteAllProcedures To Public

Go