October 24th, 2003, 07:40 AM
Fixing a Corrupt Table
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.
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?
November 5th, 2003, 05:50 AM
Just give up and let the IVR team get on with it!