What are the challenges you face when working across database platforms? Take the survey

Error in SQL Compare

InfoadvInfoadv Posts: 6
edited August 5, 2005 1:26PM in SQL Compare Previous Versions
during database comparison or during a snapshot creation I receive the following error :

unexpected char: 0xံF :shock:

Have you some suggestions to understand problem and to solve or bypass it .

Is important for me to do this compare because i'm sure that someone have damaged db where i receive error and i MUST rebuild it correctly from an old version that work fine.

Best Regards

Luca Dileo


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Luca,

    This error sounds a lot like the Unicode SQL object name got scrambled somehow. Have you tried simply running DBCC CHECKDB first to try to find errors in the database? I'll be the first to admit that if you have a corrupted database, SQL Compare is going to have problems registering it.
  • Options
    The first thing that i do is to run DBCC CHECKDB , but no errors was found in database.
    Only if i try to run DBCC CHECKTABLE , on table that i think is corrupted i receive invalid object.

    I don't known how i can do .
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    Can you do a DBCC CHECKTABLE ... REPAIR_REBUILD (making sure, of course, to back up the database first!!)
This discussion has been closed.