ColumnTracking Property
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The ColumnTracking property exposes conflict resolution behavior for rows of data merged through replication.
Sintaxis
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);
Notas
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.
[!NOTA]
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.