I have a SQL 2005 database that replicates two a second server, also SQL Server 2005 that is getting an error. I do not now what table or field the error is coming from. The error is:
Any suggestions? I looked at all the tables and fields being replicated at the time for both publisher and subscriber, but do not see any errors in the data.
Code:
Error from Replication Monitor on the Publisher:
Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x00004F1C00000830004200000000, Command ID: 3)
Error messages:
Conversion failed when converting the varchar value '124.' to data type int. (Source: MSSQLServer, Error number: 245)
Get help: http://help/245
Conversion failed when converting the varchar value '124.' to data type int. (Source: MSSQLServer, Error number: 245)
Get help: http://help/245
Any suggestions? I looked at all the tables and fields being replicated at the time for both publisher and subscriber, but do not see any errors in the data.