Changing Database Properties

[billum]

Hi,

I have some databases where the properties - Torn page detection and Auto update statistics is turned off.
Will there be any problem if I turn it on (through Ent.Mgr) when the databse is in use(When users are connected to the database)?

Thanks in advance
Bill

 

[mrdenny]

No, there shouldn't be any problem.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.

 

[SQLRickster]

No worries. If your feeling lucky you can use QA to do the same task sp_dboption '<<database name here>>','torn page detection','ON' and sp_dboption '<<database name here>>','auto create statistics','ON'

Rick

 

[SQLRickster]

My bad. The statistics one is auto update statistics not auto create statistics....