MSSQL_ENG020598 - The row was not found at the Subscriber when applying the replicated command.

Hello,

We are seeing error MSSQL_ENG020598 - "The row was not found at the Subscriber when applying the replicated command", when running peer to peer transactional replication. Unfortunately the error message provides the database in which the error occurs but not the table or SQL statement that causes the conflict.

Is there a way to determine exactly what query caused the conflict - or at least what table the error occurred in?

Thanks in advance.

If you run distribution agent in a job, you can set the OutputVerboseLevel of distribution agent profile to 2.

If you run distribution agent from command line, simply set parameter -OutputVerbloseLevel to 2.

It shows the exact SQL statement that distribution agent use.

Peng

|||Thanks, this looks like it helped.