Managing the logs

Table 7-1 names the parameters, options, and system procedures for enabling and disabling event and error logging and indicates whether they affect the two logs. It also lists the pages in this chapter that contain instructions on using these elements to refine message logging.

Table 7-1: Methods for enabling/disabling error and event logging

Method

Affects event log

Affects error log

See page

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

§