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.
· Share on Twitter

Comments

  • JonathanWattsJonathanWatts Posts: 418
    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
    · Share on Twitter
  • vhaakmatvhaakmat Posts: 3
    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
    · Share on Twitter
Sign In or Register to comment.