MSmerge_replinfo (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)