Magically disappearing tables?

  • Hello all,

    One of our clients has a handheld app using sql server ce 2000 under ce.net 4.2.  Everything going well and then today the field tech using it says it pops up an error indicating that a table has gone missing.

    Sure enough, a table is indeed missing and nothing programatically zaps it during the operation he was performing.

    Has anyone else had any issues with this or similar data corruption?  Can't find any mention of this problem in any group or website, and there's nothing much to speak of on the MS site apart from a bunch of pointers to upgrade to SQL 2005 Mobile.

    Any input would be appreciated.

    Vik

  • Someone must have accidentally deleted the table. Just restore the table from backup and close the chapter. If this keep occuring then investigate

     


    Kindest Regards,

    Amit Lohia

  • This is indeed amazing, However, there is a possiblity that sometimes the sysobjects table may go correct and so the Database engine does not finds the table.

     

    Possible reason ??

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply