Error in SQL Compare

InfoadvInfoadv Posts: 6
edited August 5, 2005 1:26PM in SQL Compare Previous Versions
Hi
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • 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 .
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

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