Replication Errors

• David Paskiet

  SSCrazy

  Points: 2949

  More actions

  December 7, 2011 at 9:56 am

  #391062

  I am getting an error while replicating a database. I am stumped on how to fix it. I am going from a SQL2K 32bit (publisher) to SQL2005 64Bit (dist and subscriber). The snapshot and publication are running fine. However, after the snapshot is applied transactions cant be applied to the subscriber. I know of one data issue which I fix on the publisher. Any insight or suggestions on a way to narrow this down wold be most appreciated.

  Database are collated similar

  Pub=SQL_Latin1_General_CP1_CI_AS

  Dist=Latin1_General_CI_AI

  SUB=SQL_Latin1_General_CP1_CI_AS

  The error i get is:

  Command attempted:

  if @@trancount > 0 rollback tran

  (Transaction sequence number: 0x00022D7800000D7C000100000000, Command ID: 7497)

  Error messages:

  •Invalid character value for cast specification (Source: MSSQLServer, Error number: 20025)

  Get help: http://help/20025

  Invalid character value for cast specification (Source: MSSQLServer, Error number: 22018)

  Get help: http://help/22018

  Kindest Regards,
  David

  ** Obstacles are those frightening things that appear when we take our eyes off the goal. **

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  December 22, 2011 at 9:27 am

  #1424852

  One question, Do you have any user defined datatype in your publisher?

  -Roy