BUG: Logreader Replicates a Combination of a Delete/Insert

• Microsoft SQL Server, version 6.0

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.

WORKAROUND

Separate the DELETE and INSERT statements into two different transactions by not using the explicit BEGIN and COMMIT TRAN statements.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.