SQL Server Script to increase number of Errorlogs
- Kunal Ranpura

- Jul 28, 2019
- 1 min read
--Below script will change the number of SQL Server errorslogs to 10
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', REG_DWORD, 10
GO







Comments