SQL 6.5 Fatal Error 605
Posted on 2009-04-30
I am running an application that uses a MSSQL 6.5 DB. It has been running fine for years. However, a couple of weeks ago, we received a fatal error 605. It stated the error was in the 'transaction' table. Unfortunately, we did not attempt to correct the problem immediately after the error appeared, so our backups will not help in this case. I also attempted to run the DBCC CHECKTABLE REPAIR_ALLOW_DATA_LOSS command before realizing that it will only work in MSSQL 7.0 +.
So, I need to know the safest (and easiest) method to correct the 605 error on the affected table. We are not SQL experts in any stretch of the imagination, so we will need as much as can be provided in snippets or step-by-step directions.
Thank you in advance for the assistance!