I have a database that was converted to xp. Before the conversion the database was fine. After the conversion the database is continualy being corrupted and needing repair. Does anyone know why this is happeing and or a fix for it?
I have also found out more about the way this db is being used. The users take direct access to the tables and aply filters. I have heard that in a multi user environment aplying filters and leaving them on could cause this coruption problem....Can anyone back that up or show me a white paper. I havent been able to find a white paper on the subject.