What are the challenges you face when working across database platforms? Take the survey
Options

Unable to cast object

StephanieStephanie Posts: 10
edited April 16, 2008 6:44AM in SQL Compare Previous Versions
I am using SQL Compare 6.2.0.271 and am receiving an error "Unable to cast object of type "System.DBNull" to type "System.String". I found an earlier post referring to permissions being the problem. I have sysadmin level authority on both servers so permissions can't be the issue.

Any other help available?

Comments

  • Options
    Michelle TMichelle T Posts: 566 Gold 1
    If you could run SQL Server Profiler against your database, and send me (michelle.taylor@red-gate.com) the last query that SQL Compare executes before returning that error message, along with the results of that query, we should be able to find out what's wrong.

    The most likely cause is that there is some object in your database with very strange properties, possibly inherited from pre-7 versions of SQL Server or introduced by an application. If you could run dbcc checkdb and tell us if it reports any problems with the database, that may also be useful.
    Software Developer
    Redgate Software
  • Options
    Info is on the way via email -- Thank!
  • Options
    Resolution -- found 1 table and 1 stored proc that had null as the owner. Modified sysobjects to change uid to 1. Compare worked after that.
Sign In or Register to comment.