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	§