New system procedures

Table 5-11 lists the new system procedures that support the expanded error logging feature.

Table 5-11: New system procedures for expanded error logging

System Procedure

Description

sp_altermessage

Enables and disables the logging of a system-defined or user-defined message in the Adaptive Server error log.

sp_configure

"log audit logon success"

Specifies whether to log successful Adaptive Server logins to the Adaptive Server error log and, on Windows NT servers, to the Windows NT Event Log, if event logging is enabled.

"log audit logon failure"

Specifies whether to log unsuccessful Adaptive Server logins to the Adaptive Server error log and, on Windows NT servers, to the Windows NT Event Log, if event logging is enabled