error while comparing: Object cannot be cast from DBNULL

vhaakmatvhaakmat Posts: 3
edited March 9, 2007 7:46AM in SQL Compare Previous Versions
After I tried an update I am getting this error:
In the section registering databases: serverx.datbasex-Reading columns
Object cannot be cast from DBNULL to other types.

Comments

  • Hi there,

    Can you confirm that the login that you are using is dbo in the databases that you are comparing?

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
  • I found the problem... one of the tables got corrupted in the identity field (autoincrement) instead of a number it had a bunch of weird characters. I deleted them and put back the 1... that fixed it..
    However you may need to look into this, what may have caused the error

    thanks

    Vincent
Sign In or Register to comment.