Generate WindowsEventlog entry for certain severity levels

• Pieter-423357

  SSCommitted

  Points: 1619

  More actions

  August 12, 2016 at 8:51 am

  #320608

  I like SQL Server 2012 to push severity level error messages of 11 and above in to the Windows Event log. The thought would be that I can use a tool like Splunk to then alert me of this event, at the very minimum permit review after the fact. I can setup an Alert and found plenty of examples, but Alerts don't offer to write to Windows Event logs. Any suggestions?

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  August 12, 2016 at 11:28 am

  #1895265

  Take a look at sp_altermessage. You can set the Is_event_logged value in sys.messages with something like:

  EXEC sp_altermessage

  @message_id = NNNNN, --Your message number

  @parameter = 'WITH_LOG',

  @parameter_value = 'True'

  Sue