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
                  EXEC('drop procedure ' + @procName)
                  fetch NEXT FROM cur INTO @procName
      close cur
      deallocate cur