MSmerge_contents

Transact-SQL Reference

Transact-SQL Reference

MSmerge_contents

The MSmerge_contents table contains one row for each row modified in the current database since it was published. This table is used by the merge process to determine the rows that have changed. This table is stored in the publication and subscription databases.

Column name Data type Description
tablenick int Nickname of the published table.
rowguid uniqueidentifier Row identifier for the given row.
generation int Generation of the row identified by the tablenick and rowguid.
partchangegen int The generation associated with the last data change that could have changed whether the row belongs in a filtered publication.
joinchangegen int The generation associated with the last data change to this row that would have changed whether related rows belong in a filtered publication.
lineage varbinary(249) Subscriber nickname, version number pairs that are used to maintain a history of changes to this row.
colvl varbinary(2048) Column version information.