ColumnTracking Property
后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。
The ColumnTracking property exposes conflict resolution behavior for rows of data merged through replication.
语法
object
.ColumnTracking [=value]
Parts
object
An expression that evaluates to an object in the Applies To listvalue
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetColumnTracking(LPBOOL pRetVal);
HRESULT SetColumnTracking(BOOL NewValue);
注释
If TRUE, each column in a row participates individually in conflict determination and resolution. If more than one site modifies the row, but each site modifies a unique set of columns, no conflict is found and all changes are merged.
If FALSE, the entire row is evaluated to determine conflicts.
注意 |
---|
If an application sets ColumnTrackingafter the initial snapshot has been created, a new snapshot must be generated and then reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and merge agent run. |