Monday, 18 July 2011

Increase number of ERRORLOGs

-- Increase number of ERRORLOGS to 20, change last value if needed
-- From
http://support.microsoft.com/kb/196909

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', REG_DWORD, 20