February 22, 2011 at 3:53 am
Hi All,
It turned out that on my SQL 2K5 64bit the following configuration has been set up:
NAME: allow updates
MINIMUM: 0
MAXIMUM: 1
CONFIG_VALUE: 1
RUN_VALUE: 1
Now I read that on 2K5 it has no effect anymore as modification to system tables are not supported. My question is whether are there any impacts if I set it to the default value of OFF? I would like to do so as the integrity check maint plan keeps failing and this seems to be a workaround.
I would be also interested in knowing a few examples when you need to set it ON and why it is beneficial. If anyone could share his/her thoughts on this I would be thankful.
__________________________
Allzu viel ist ungesund...
February 22, 2011 at 4:34 am
Turn it off. It doesn't need to be on for anything, all having it on will do is throw an error when a RECONFIGURE is run.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2011 at 5:15 am
I appreciate your response Gail. Thank you.
__________________________
Allzu viel ist ungesund...
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply