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 both the Adaptive Server error log and in the NT event log.
For the complete syntax for the sp_addmessage and sp_altermessage system procedures, see the Adaptive Server 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.
Use the xp_logevent extended stored procedure to set up logging of user-defined events in the NT event log in Adaptive Server.