Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Row Level Tracking
- Thread starter stotzc001
- Start date
From MSDN:
'A column (cell) is the most basic unit of information recognized in replication when the ColumnLevelTracking property is set on the table. In this case, nonconflicting fields are merged when changes are transmitted during synchronization. When the RowLevelTracking property is set on the table, if any field in a row (record) is modified, the whole record is marked as changed. Therefore, the whole record is updated when changes are transmitted during synchronization and individual fields are not merged. With row-level tracking, OLE Object and Memo fields are exceptions; these items—due to their potential large size—are not transmitted unless they have been changed.'
'A column (cell) is the most basic unit of information recognized in replication when the ColumnLevelTracking property is set on the table. In this case, nonconflicting fields are merged when changes are transmitted during synchronization. When the RowLevelTracking property is set on the table, if any field in a row (record) is modified, the whole record is marked as changed. Therefore, the whole record is updated when changes are transmitted during synchronization and individual fields are not merged. With row-level tracking, OLE Object and Memo fields are exceptions; these items—due to their potential large size—are not transmitted unless they have been changed.'
- Status
Similar threads
- Locked
- Question
- Locked
- Question