MSmerge_replinfo (Transact-SQL)

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.