Sybase DC35823-01-1500-04 manual Managing messages, Logging user-defined messages, 107

CHAPTER 8 Logging Error Messages and Events

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.

Configuration Guide 107