Sybase DC35823-01-1500-04 Manual de usuario descargar pdf (Pagina 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.

1 2 ... 118 119 120 121 122 123 124 125 126 127 128 ... 149 150

Sin comentarios

Sybase DC35823-01-1500-04 Manual de usuario Pagina 123