MSmerge_replinfo

Transact-SQL Reference

Transact-SQL Reference

MSmerge_replinfo

The MSmerge_replinfo table contains one row for each subscription. This table tracks internal information about the sent and received generation. This table is stored in the publication and subscription databases.

Column name Data type Description
repid uniqueidentifier Unique ID for the replica.
replnickname int Compressed nickname for the replica.
recgen int Number of the last generation received.
recguid uniqueidentifier Unique ID of the last generation received.
sentgen int Number of the last generation sent.
sentguid uniqueidentifier Unique ID of the last generation sent.
schemaversion int Number of the last schema received.
schemaguid uniqueidentifier Unique ID of the last schema received.
merge_jobid binary(16) Merge job ID for this subscription.
snapshot_jobid binary(16) Snapshot job ID servicing this publication.