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. |