BUG: Logreader Replicates a Combination of a Delete/Insert

SYMPTOMS

The logreader task replicates a delete and a subsequent insert transaction on a particular table as a single update transaction on the subscriber. The necessary conditions are that the delete and insert implicit transactions must be in turn enclosed in an explicit transaction defined using BEGIN TRAN and COMMIT TRAN statements. In addition, the delete transaction must include reference, in the where clause, to the primary key column of the table. If the above conditions are met, the logreader task processes the combination of delete and insert as a singular update that is registered in the MSjob_commands table in the distribution database on the distributor.