ColumnTracking Property

SQL-DMO

SQL-DMO

ColumnTracking Property

The ColumnTracking property exposes conflict resolution behavior for rows of data merged through replication.

Applies To
MergeArticle Object
Syntax

object.ColumnTracking [= value]

object

Expression that evaluates to an object in the Applies To list

Value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetColumnTracking(LPBOOL pRetVal);

HRESULT SetColumnTracking(BOOL NewValue);

Remarks

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.

Note  If an application sets ColumnTracking after the initial snapshot has been created, a new snapshot must be generated and reapplied to each subscription. Snapshots are applied when the next scheduled snapshot and merge agent run.