SQL Server Beta Admin Blogs

Most Recent Blog Posts

Mar 24

Written by: Sarah
Tuesday, March 24, 2009 

In my ongoing effort to automate everything.  I wanted to have a script that would change the default number of error logs.   After some looking around in help and on the internet, I realized I was going to have come up with a solution on my own.   I was complaining to Ryan about having to do some real work,  when he suggested that I just run a trace when  I make the change via Management Studio.

Here is the result:  

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

I am sure using this is not recommended, but then MS should have provided me a better method to accomplish this. 

 

Tags:

Your name:
Your website:
Title:
Comment:
Add Comment   Cancel