SQL 2005 Enterprise X64 SP4
ALERTS: SQL SERVER EVENT ALERT ---->Severity
Has anyone noticed that the Alerts only seem to trigger when the "Event" is logged to the Errorlog?
Anything that does not end up in the log does not seem to produce an alert response or update the alert history.
I can recreate this easily:
RAISERROR('Error test, 16, 1) WITH LOG; -- This triggers alert successfully
RAISERROR('Error test, 16, 1); -- This will not
My problem is I would like non-user defined errors to trigger alerts.
For example: Msg 8134, Level 16, State 1, Line 1
Is this a known bug? Are there configuration settings to change what errors are recorded in the log?
Can I send all Severity 16 to the log? (without raiserror)
Thanks for your help.