MSmerge_genhistory

Transact-SQL Reference

Transact-SQL Reference

MSmerge_genhistory

The MSmerge_genhistory table contains one row for each generation that a Subscriber knows about (within the retention period). It is used to avoid sending common generations during exchanges and to resynchronize Subscribers that are restored from backups. This table is stored in the publication and subscription databases.

Column name Data type Description
guidsrc uniqueidentifier Global identifier of the changes identified by generation at the Subscriber.
guidlocal uniqueidentifier Local identifier of the changes identified by generation at the Subscriber.
pubid uniqueidentifier Publication identifier.
generation int Generation value.
art_nick int Nickname for the article.
nicknames varbinary(1000) A list of nicknames of other Subscribers that are known to already have this generation. Used to avoid sending a generation to a Subscriber that has already seen those changes. Nicknames in the nicknames list are maintained in sorted order to make searches more efficient. If there are more nicknames than can fit in this field, they will not benefit from this optimization.
coldate datetime Date when current generation is added to the table.