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

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
    · Share on Twitter
  • Options
    StephanieStephanie Posts: 10
    Info is on the way via email -- Thank!
    · Share on Twitter
  • Options
    StephanieStephanie Posts: 10
    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.
    · Share on Twitter
Sign In or Register to comment.