CHAPTER 8 Logging Error Messages and Events
Configuration Guide 107
Managing messages
When event logging is enabled, you can manage its functions in the following
ways:
•Use
sp_addmessage or sp_altermessage to control whether a specific
user-defined message is logged in the Adaptive Server error log.
For the complete syntax for sp_addmessage and sp_altermessage, see the
Reference Manual.
• Use configuration parameters to specify whether auditing events are
logged. Auditing events pertain to a user’s success, log audit logon success,
or failure, log audit logon failure, in logging in to Adaptive Server.

Logging user-defined messages

You can specify whether a user-defined message is logged to the Adaptive
Server error log. Adaptive Server lets you make this determination for:
• New messages (sp_addmessage).
• Existing messages (sp_altermessage).
For more information about these commands and their parameters, see
sp_addmessage and sp_altermessage in the Reference Manual.

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 that the message appears.

Existing messages

Include the with_log option in sp_altermessage to change an existing user-
defined message. This parameter alters the reporting status of that message:
• TRUE – to enable logging.
• FALSE – to disable logging.