I have a transactional replication topology that consists of SQL 2005 and SQL 2000.
I managed to generate the snapshot but when I try to apply it on the subscribers, I get the following error:
Error number 20598: "The row was not found at the Subscriber when applying the replicated command".
Using “Skip Error” doesn’t resolve the issue.
My user tables are heavily used/modified. When the publisher is in single user more, I do not have this issue.
I had “READ_COMMITTED_SNAPSHOT ON” and “ALLOW_SNAPSHOT_ISOLATION ON” enabled on the database
I used @sync_method =’concurrent’