Mass Update to Clear 66,000 Alerts

linque

I woke up at 3:30 this morning to about 66,000 "SQL Server error log entry" alerts about the transaction log file being full on one of my hosted databases. Thank goodness SQL Monitor stops sending emails once it hits 1000 in a 24-hour period. Is there a safe way to mass update all of the alerts to clear them from the screen? I'm running SQL Monitor 4.1.0.2226. I can only do 100 at a time through the front end, and doing them 100 at a time will take all day. I want them all marked as cleared.

linque

I'm an idiot. There is an option to check all alerts (not just the ones showing) that was right in front of my face the entire time. I'm good now. :oops:

rayherring

linque wrote:

I'm an idiot. There is an option to check all alerts (not just the ones showing) that was right in front of my face the entire time. I'm good now. :oops:

Sure wish you'd said where the option is. I must have mud in my eye because I don't see it.

linque

Do the "Select" drop down like you're going to clear all of the alerts, and choose ALL. Once you do that, you will see the option.

rayherring

Hey Thanks for the reply.
I have a similar problem. 50K+ entries of SQL Error log for a failed disk ( fortunately on a Dev server:)