Filter
Top Products
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.