Parameters, options, and system procedures for enabling and disabling event and error logging and whether they affect the Adaptive Server error log, Windows event log, or both.
Method |
Affects Event Log |
Affects Error Log |
|---|---|---|
error logging configuration parameter |
Yes |
No |
event log computer name configuration parameter |
Yes |
No |
Server Config Event Logging option |
Yes |
No |
Server Config Error Log Path option |
No |
Yes |
sp_altermessage system procedure |
Yes |
Yes |
sp_addmessage system procedure |
Yes |
Yes |
log audit logon success configuration parameter |
Yes |
Yes |
log audit logon failure configuration parameter |
Yes |
Yes |
xp_logevent system extended stored procedure |
Yes |
No |