Most common is a db maintenance plan that is set to repair errors. I know there was a bug in earlier versions (but not SP2 I thought) where sometimes the plan wouldn't restore the bug. For a while I had a job that ran at 6 am to do nothing but make sure the mode set correctly for all db's! Another possibility is you have some process running at night that is setting it and not resetting it when done.