December 7, 2011 at 9:56 am
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. **
December 22, 2011 at 9:27 am
One question, Do you have any user defined datatype in your publisher?
-Roy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply