"Specified cast is not valid"

• 
  Local database and logging in as sa

  michaell1999 March 12, 2007 16:54

  - 0 +
• 
  Hi there,
  
  As you are sa this is a rather worrying problem as my first response would be that you have a permissions issue. Are you able to supply us with a copy of the database schema so that we can take a closer look at your problem?
  
  If this is not possible could you run a trace with SQL Profiler whilst you are attempting to connect to the database with SQL Compare and email the result to jonathan [dot] watts [at] red [dash] gate [dot] com.
  
  Regards,
  
  Jonathan

  JonathanWatts March 13, 2007 06:01

  - 0 +
• 
  I sent the profiler trace

  michaell1999 March 13, 2007 10:45

  - 0 +
• 
  Was there ever any follow up to this particular issue? I appear to be running into almost the exact same problem.
  
  Same version of the sql compare: 5.3
  Same version of SQL database: SQL server 2000
  
  Happening with a specific database after I had made schema changes and then attempting to compare the. Previously I was able to successfully use the compare tool with this database so I assume it must be in the changes I made.

  TSRife April 12, 2007 09:02

  - 0 +
• 
  After reading through the details of the first post in the thread I notice my issue is slightly different. When doing the compare my 'Specified cast is not valid' error appears to occur in the 'Registering databases' -> 'Reading tables' step
  
  Not sure if that will be of any additional assistance but I thought I'd bring it up

  TSRife April 13, 2007 14:45

  - 0 +
• 
  Hi TSRife.
  
  Can you confirm that you are running as sa or as dbo of the database?
  
  Thanks,
  
  Jonathan

  JonathanWatts April 13, 2007 16:52

  - 0 +
• 
  Jonathan,
  
  I have verified that I am running under as dbo for the database in question. This is a development database so we have full control. Per your request earlier in the thread I have forwarded a SQL profiler trace file to your address provided in case that would offer any insight.

  TSRife April 18, 2007 14:27

  - 0 +
• 
  Hi there,
  
  Sorry about the delay in replying. I have sent you an email with some futher instructions for debuging your problem.
  
  Regards,
  
  Jonathan

  JonathanWatts April 24, 2007 07:22

  - 0 +

Add comment

Please sign in to leave a comment.