INF: Trace Flag to Replicate UPDATE as DELETE/INSERT Pair

 Last reviewed: March 28, 1997
Article ID: Q160181
The information in this article applies to:
  • Microsoft SQL Server version 6.5 Service Pack 2
BUG #: 16019 (6.5)

SUMMARY

Logreader replicates some UPDATE statements as UPDATE commands and others as DELETE/INSERT pairs. This article discusses the optional trace flag to replicate all UPDATE commands as DELETE/INSERT pairs.

MORE INFORMATION

UPDATE commands at the publisher can be run as an "on-page DELETE/INSERT" or a "full DELETE/INSERT," depending on the data being updated. For more information on different update methods in SQL Server, see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q135871
   TITLE     : INF: Update Methods Used in SQL Server 6.0
If the UPDATE command is run as an "on-page DELETE/INSERT," the Logreader reconstructs the UDPATE command to be sent to the subscriber. However, if this UPDATE does not qualify for "on-page DELETE/INSERT," it is run as "Full DELETE/INSERT." In such cases, the Logreader constructs a DELETE command followed by an INSERT command.

To ensure that an UDPATE statement is sent to the subscriber as UPDATE, it is sometimes possible to modify the UPDATE statement at the publisher, to suit the requirements of an "On-page DELETE/INSERT." In other cases, it may not be possible to modify the UDPATE statement at the publisher. To ensure uniformity in these cases, trace flag 8202 can be enabled at the publisher. This trace flag, available starting with U.S. SQL Server 6.5 Service Pack 2, will make the Logreader replicate all UDPATE commands as DELETE/INSERT pairs at the subscriber.

For information on enabling trace flags, refer to the SQL Server documentation under "Additional Problem Solving Techniques."

Additional query words: SP2 del/ins
Keywords : kbusage SSrvRep kbbug6.50 kbfix6.50.sp2
Version : 6.5 SP2
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.