合并期间的CT表行为 [英] CT Table Behavior during Merge

问题描述

您好，

我有事务表，其中CDC已启用，我有一个sp在此表上执行合并更新和插入。

但对于所有更新，CT表将跟踪它们作为删除（操作1）和插入（操作2），其中我正在操作操作3和操作4。

任何人都可以帮助我理解为什么通过合并创建具有操作1和操作2的记录以进行更新。

提前致谢，

Rahul

解决方案

< blockquote>

您可能会遇到延期更新。 

https://support.microsoft.com/en-us/help/238254/update-statements-may-be-replicated-as-delete-插入对

您可能需要使用跟踪标志8202来禁用此行为。

Hello,

I have transaction table where CDC is Enabled,I have a sp that does a Merge on this table for Updates and Inserts.

But for all the Updates,CT table is tracking them as deletes(operation 1) and Inserts(operation 2) where as i am expectiing operation 3 and Operation 4.

Can anyone please help me understand why records with operation 1 and Operation2 are being created for Update through Merge.

Thanks in Advance,

Rahul

解决方案

You could be running into deferred updates. 

https://support.microsoft.com/en-us/help/238254/update-statements-may-be-replicated-as-delete-insert-pairs

You may need to use trace flag 8202 to disable this behavior.

这篇关于合并期间的CT表行为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！