Unable to cast object error

• 
  This bug has been fixed in the latest version of SQL Compare (6.2). Essentially there were some system objects which were getting picked up by Compare if they were present in the database, and because they didn't return all of the information that a real object would, this error resulted.

  Michelle T December 12, 2007 06:18

  - 0 +
• 

  Michelle Taylor wrote:

  This bug has been fixed in the latest version of SQL Compare (6.2). Essentially there were some system objects which were getting picked up by Compare if they were present in the database, and because they didn't return all of the information that a real object would, this error resulted.

  
  I am still getting this error in SQL Compare 6.2.0.271. I think it is some sort of permissions thing because if I log in as SA it works. Is there a list of DB permissions somewhere needed to use this tool?

  jfuex February 14, 2008 15:51

  - 0 +
• 
  There's a Knowledge Base article explaining what permissions you should need for SQL Compare:
  
  https://www.red-gate.com/support/kb/KB200707000072.htm
  
  The error is caused by one of the queries we use to get information from the database returning a NULL value unexpectedly, which may happen if you have an object which you don't have permission to find out certain information about.
  
  If you're following the advice in the article and still having problems, please contact us again and I'll have a look into whether there are actually other permissions required to get all the information out of your database.

  Michelle T February 15, 2008 06:47

  - 0 +
• 
  That did it. Thanks for the point in the right direction.

  jfuex February 15, 2008 10:28

  - 0 +

Add comment

Please sign in to leave a comment.