What Corrupted an MS SQL 2000 Table ?
Recently a key student information table that I've been working on was corrupted while I was demonstrating the database to staff when the Server was having a service pack installed.
The Access client started to run slowly and then I got an error message stating that it was not possible to save this record because another user user is writing to this record. The client then lost its connection to MS SQL Server because the Server was rebooting.
So I slogged through all of the possible causes until I found out that Server had been upgraded during my training session with the office staff. The table has been corrupted and I've had to do another datatransfer.
I think that the Server Upgrade is the most likely cause of this problem, has anyone encountered this issue before ?