MSmerge_replinfo (Transact-SQL)
Applies to: 
SQL Server
The MSmerge_replinfo table contains one row for each subscription. This table tracks information about subscriptions. This table is stored in the publication and subscription databases.
| Column name | Data type | Description |
|---|---|---|
| repid | uniqueidentifier | The unique ID for the replica. |
| use_interactive_resolver | bit | Specifies whether the interactive resolver is used during reconciliation. 0 = Do not use the interactive resolver. 1 = use the interactive resolver. |
| validation_level | int | Type of validation to perform on the subscription. The validation level specified can be one of these values: 0 = No validation. 1 = Rowcount-only validation. 2 = Rowcount and checksum validation. 3 = Rowcount and binary checksum validation. |
| resync_gen | bigint | The generation number that is used for resynchronization of the subscription. A value of -1 indicates that the subscription is not marked for resynchronization. |
| login_name | sysname | The name of the user who created the subscription. |
| hostname | sysname | The value that is used by the parameterized row filter when generating the partition for the subscription. |
| merge_jobid | binary(16) | The merge job ID for this subscription. |
| sync_info | int | Internal-use only. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for