| title | MSmerge_replinfo (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | replication | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | b0924094-c0cc-49c1-869a-65be0d0465a0 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)