"Disable auto update statistics"

Hello,

In our SAP prod database we have "auto update statistics" set "on" - I want to disable this and run "update statistics" after hours. If I uncheck the flag, is it a dynamic change or do I have to stop/start SQL for the change to take affect ? We are running SQL 2000.

Thanks

Message was edited by:

Brian Anastasia

Message was edited by:

Brian Anastasia