How to exclude SQL Error Log alerts for certain errors and clients?
Apparently, our network admins use a port vulnerability scanner that causes a variety SQL Server Error Log errors. With the default settings, these fired SQL Monitor alerts, which sent a flood of email notifications to my team (my bad). I want to find a way to exclude these from SQL Monitor alerts. However, I would prefer not to just completely stop/exclude all alerts with these error #s as I would like to be notified when we get "real" errors. I considered excluding errors with messages that contained [CLIENT: ##.###.##.##] (the scanner IP address). Unfortunately, there are separate lines in the error log for the Error and the Message that contains the CLIENT IP. Any advice on handling this situation?