Contains one row for each subscription. This table tracks internal information about the sent and received generation. This table is stored in the user database.
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. |