#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    1
    Rep Power
    0

    Question 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?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    25
    Rep Power
    0
    Just give up and let the IVR team get on with it!

IMN logo majestic logo threadwatch logo seochat tools logo