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