You can specify whether a user-defined message is logged to
the Adaptive Server error log as well as to the Windows event log.
Adaptive Server lets you make this determination for:
New messages (sp_addmessage)
Existing messages (sp_altermessage)
See sp_addmessage and sp_altermessage in the
Reference Manual: Procedures.
New Messages
Include the with_log option in sp_addmessage when you add a new user-defined message to sysusermessages. This parameter sets the Adaptive Server to log the message each time the message appears.
Existing Messages
Include the with_log option in sp_altermessage to change an existing user-defined message.