June 28, 2006 at 8:58 am
I am running transactional replication with 4 subscriptions. I received a message of String or binary data would be truncated on one subscription but the other 3 are running fine. I tried to re-start synchronizing on the subscription but keep getting the same error. How do I clear the error and start synchronizing again. I check the other three subscription and the record in question has be inserted into the table. Any help would be greatly appreciated.
Thanks
David Schuster
June 28, 2006 at 9:05 am
Does the schema match on all the subscribers?
It appears that one of the destination tables does not match the source table. Specifically the char, or varchar size of a column is not big enough to put in the replicated value. Fix this, and you should be able to restart replication.
June 28, 2006 at 9:05 am
David
Make sure that the columns in the tables in your subscription database have exactly the same data types as those in your publication database. It sounds as if you're trying to insert some data from a wide column into a narrow column, for example a 20-character string into a varchar(10) column.
John
June 28, 2006 at 9:24 am
All tables in all database are exactly the same. It is a varchar(3000) data type. I don't want to have to deleted the subscription and re-create it but I know that will work because I have done it in the past.
David
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply