
October 24th, 2003, 07:40 AM
|
|
Junior Member
|
|
Join Date: Oct 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Fixing a Corrupt Table
Hi,
I have a problem with a table in a SQL 7.0 database. Somehow, the table has become corrupt and I am receiving the following error message when I try to select (or try to do anything) from the table.
Location: Logrec.cpp:399
Expression: False
Description: Invalid Switch Value.
I think the error is in the MSSQL Server code. In order to get the data out I have tried to run DBCC CheckTable using the option to permit data loss although this does not fix the problem.
Has anyone any ideas of how I may be able to get the data out of the table or do I have to give up and accept that the data is lost?
Any suggestions?
|