• 
  Hi Nigel, 
  
  Thanks for your post!
  
  You can do this as per JoeHarkins post below.
  
  Let us know!
  

  Robyn September 19, 2019 11:25

  - 0 +
• 
  Hi Robyn and Nigel,
  
  The product indicates that it will accept a regex filter to stop certain alerts in the error log. 
  If you go to 

  Configuration > Alert settings > SQL Server error log entry | All Servers

  
  You can choose to exclude by any of the following: 
  

  • Exclude error log entries by severity matching the following regular expressions
  • Exclude error log entries by error number matching the following regular expressions
  • Exclude error log entries by error message matching the following regular expressions

  Cheers,
  
  Joe
  
  

  JoeHarkins October 31, 2019 17:33

  - 0 +
• 
  Sorry for the double post. It won't let me delete the duplicate, so here's a fun fact for the day: 
  Most of the construction of a didgeridoo is completed by termites, who hollow out the trunks.
  
  

  JoeHarkins November 01, 2019 08:55

  - 0 +
• 
  I've seen the alert exclusion but was thinking more of wheres its displayed on the instance page. I use Idera's Compliance Manager and it starts and stops traces every few minutes which tend to flood the SQL Log.
  There used to be a trace flag (3688) that could be set to suppress these entries but that seems to have been discontinued in recent versions.

  AndrewL December 05, 2019 11:07

  - 0 +
• 
  I also have issues on those scanners alerts that I want to exclude from severity 014 insufficient permission. But I couldn't find where is your above displayed on the instance page to have following interface to let me setup? Please advise!
  
  Configuration -> Alert Settings -> SQL Server error log entry -> All servers

  KHsql01 April 26, 2022 21:02

  - 0 +

Add comment

Please sign in to leave a comment.