Delete All SQL Server Alerts

--**** DANGER DELETE ALL ALERTS
-- http://larsrasmussen.blogspot.com
--
-- Note: Remove ROLLBACK and uncomment COMMIT at end of script if you really want to do this
--
-- Example
-- EXEC msdb.dbo.sp_delete_alert @name=N'Error 00601'
--
-- Stolen/adapted from Tibor Karazi
-- http://www.karaszi.com/SQLServer/util_agent_alerts.asp
-- http://www.karaszi.com/SQLServer/code/AgentAlertsManagementPack.sql.txt
BEGIN TRAN

SELECT *
FROM msdb.dbo.sysalerts

DECLARE c CURSOR
FOR
SELECT NAME
FROM msdb.dbo.sysalerts

DECLARE @msg_name NVARCHAR(128)
    ,@sql VARCHAR(2000)

OPEN c

WHILE 1 = 1
BEGIN
    FETCH NEXT
    FROM c
    INTO @msg_name

    IF @@FETCH_STATUS <> 0
        BREAK

    SET @sql = 'EXEC msdb.dbo.sp_delete_alert @name=N''' + @msg_name + ''''

    PRINT @sql

    EXEC (@sql)
END

CLOSE c

DEALLOCATE c
GO

SELECT *
FROM msdb.dbo.sysalerts

--REMEMBER TO
--COMMIT
ROLLBACK