Manage Messages

When event logging is enabled, you can manage its functions.

You can:

Use sp_addmessage to add a user message, or sp_altermessage to control whether a specific message is logged in both the SAP ASE error log and in the Windows event log.

For the complete syntax for the sp_addmessage and sp_altermessage system procedures, see the Reference Manual: Procedures.
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 SAP ASE.
Use the xp_logevent extended stored procedure to set up logging of user-defined events in the Windows event log in SAP ASE.

Log User-Defined Messages
You can specify whether a user-defined message is logged to the SAP ASE error log as well as to the Windows event log.
Log Auditing Events
By default, SAP ASE does not log auditing events. However, you can use sp_configure parameters to specify whether SAP ASE is to log auditing events, such as logins, to the SAP ASE error log and to the Windows event log.
Log User-Defined Events
You can arrange to have user-defined events logged to the Windows event log from within SAP ASE. For example, you can create a “database imported” event that is generated after a database has been imported successfully.

Parent topic: Log Error Messages and Events