Sybase DC35823-01-1500-04 - Manual (Page 123)

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.