How can we help you today? How can we help you today?

Unable to cast object

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?
Stephanie
0

Comments

3 comments

Sort by
  • Michelle T
    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.
    Michelle T
    0
  • Stephanie
    Info is on the way via email -- Thank!
    Stephanie
    0
  • Stephanie
    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.
    Stephanie
    0

Add comment

Please sign in to leave a comment.