quote:

---

You can set in EM by right clicking the error log folder. Profiling that reveals the following:

xp_instance_regwrite N'HKEY_LOCAL_MACHINE', SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorlogs', REG_DWORD, 8

---

Cool! I never noticed that EM feature before! 🙂 I too found it by doing a profiler trace one day. The key is nice to know when you're trying to roll it out to lots of servers, but I like the EM method that Andy shows for lowering the risk.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight