BUG: Logreader Replicates a Combination of a Delete/Insert (155862)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q155862
BUG #: 14461
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.
Modification Type: | Minor | Last Reviewed: | 3/14/2005 |
---|
Keywords: | kbBug kbnetwork KB155862 |
---|
|