Invalid Cast

• 
  Hi Glen,
  
  Do all of the database objects have an owner? I don't know exactly how it happened, but on one occaision a user had a database with a table in it that had no owner. That made SQL Compare try to compare a text value to a NULL value, which caused an invalid cast exception.

  Brian Donahue September 14, 2004 10:58

  - 0 +
• 
  Object cannot be cast from DBNull to other types
  
  Is this similar to the topis above, and it not how do I solve this error when trying to do a comparison.
  
  Thank you

  fraudh8er October 01, 2004 11:50

  - 0 +
• 
  Is there any way you can get a copy of the database which gives this error to me? The best way would be to back it up, zip it, and e-mail it to me at support@red-gate.com
  
  - Neil

  Neil Davidson October 01, 2004 12:00

  - 0 +
• 
  Do you want me to send you both databases, I dont get the error until I do that sync. The datanases work fine before the sync is done. Do you still want to databases?

  fraudh8er October 01, 2004 12:09

  - 0 +
• 
  Yes please.

  Neil Davidson October 01, 2004 12:13

  - 0 +
• 
  Do you want a copy of the database before or after the sync is done?

  fraudh8er October 01, 2004 12:31

  - 0 +
• 
  Can you give a copy of the databases in the state they're in when you get the error please.

  Neil Davidson October 01, 2004 12:43

  - 0 +
• 
  it is on it way
  
  Thank you Neil

  fraudh8er October 01, 2004 13:15

  - 0 +
• 
  Thanks for e-mailing me the backups.
  
  It seems like something odd has happened to the database. If you run an sp_help against Nightly_Print_Log on DB_2_4_Neil.bak then you'll see that the seed and increment values for the identity columns are both NULL. This should never happen. If you go into Enterprise manager and change the seed and increment values to something else (eg to 2, and then back to 1) then that should fix it.

  Neil Davidson October 04, 2004 12:03

  - 0 +

Add comment

Please sign in to leave a comment.