Unable to cast object of type redgate.sqlcompare.engine.stat

• 
  Can you confirm the version of SQL Doc and the version of SQL Server please?

  chriskelly October 27, 2011 11:59

  - 0 +
• 
  SQL Server 2008
  
  SQL Doc 2 (Most recent release, downloaded & installed yesterday)

  msigman October 27, 2011 12:00

  - 0 +
• 
  Can you try installing the patch detail on this forum post:
  
  http://www.red-gate.com/messageboard/vi ... php?t=9983

  chriskelly October 27, 2011 12:07

  - 0 +
• 
  It says that SQL Doc 2.1 is already installed. Apparently that patch comes pre-installed on the latest download.

  msigman October 27, 2011 12:21

  - 0 +
• 
  I am also having this issue - any fixes yet???

  hazelj November 02, 2011 10:57

  - 0 +
• 
  Having the same problem
  
  Trying to document SQL 2005 server
  SQL Doc version 2.1.0.223

  jfichera November 17, 2011 12:55

  - 0 +
• 
  Thank you for your posts.
  
  Basically SQL Doc is suffering from a small change in the SQL Compare engine which it uses to gather data about the schema. The development team now believe that they know what the problem is so hopefully there will be a fix soon (although i cannot say when at the moment).
  
  A possible workaround which has helped another user (to an extent) is to remove any manually created statistics and then SQL Doc 'should' be able to successfully document the schema. While I know that this is in no way ideal, hopefully it will only be required in the short term.

  chriskelly November 17, 2011 13:11

  - 0 +
• 
  I just downloaded this product and the first time i use it i get this error.
  Also what does it mean to remove manual statistics?

  zsbostonma December 05, 2011 15:08

  - 0 +
• 
  We had just fixed this yesterday and have a patch for it. DO NOT install this patch unless you have the problem above! Thanks.
  ftp://support.red-gate.com/patches/sql_ ... .0.242.zip

  Brian Donahue December 06, 2011 05:27

  - 0 +

Add comment

Please sign in to leave a comment.