Sybase Adaptive Server, Configuration Manual

Page: 123 / 150

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.