Problem:
Checking MSSQL: Select * from sys.messages where message_id = 1205
--shows field is_event_logged equals 0
Solution:
In MSSQL: Exec sp_altermessage 1205, 'WITH_LOG', 'true'
*If a message is written to the Windows Application log, it is also written to the Database Engine Error Log file.
Image 1: (Systems Center...configuration is ok here)
Image 2: (Systems Center...configuration is ok here)
Image 3: (Systems Center...configuration is ok here)
Image 4: (MSSQL...configuration needed to be modified here)
Resources:
sys.messages
|
|
|
|
|
|