SQL 2005 Error Message when running DBCC CheckDB – Configuration option ‘allow updates’ changed from 0 to 0. Run the RECONFIGURE statement to install.

Then get:

 

Msg 5834, Level 16, State 1, Line 1
The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration.

 

Use this to fix it:

 

sp_configure ‘Allow Updates’, 0
RECONFIGURE WITH OVERRIDE

Leave a Reply

Your email address will not be published. Required fields are marked *