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. |
See Also
Reference
Replication Views (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)