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.


  • Options
    Hi there,

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


    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
  • Options
    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


Sign In or Register to comment.