共用方式為


How to: Specify the Conflict Tracking and Resolution Level for Merge Articles (Replication Transact-SQL Programming)

When a subscription to a merge publication is synchronized, replication checks for conflicts caused by changes to the same data made at both the Publisher and the Subscriber. You can specify whether conflicts are detected at the row-level, where any change to the row is considered a conflict, or column-level, where only changes to the same row and column are considered a conflict. Conflict resolution for articles is performed at the row-level. For more information on conflict detection and resolution when logical records are used, see 偵測和解決邏輯記錄中的衝突. You can specify programmatically how conflicts are tracked when creating articles and after an article has been defined.

To specify conflict tracking options for a new merge article

  1. At the Publisher on the publication database, execute sp_addmergearticle and specify one of the following values for @column_tracking:

    • true - Use column-level tracking for the article.
    • false - Use row-level tracking, which is the default.

To change conflict tracking options for a merge article

  1. To determine the conflict tracking options for a merge article, execute sp_helpmergearticle. Note the value of the column_tracking option in the result set for the article. A value of 1 means that column-level tracking is being used, and a value of 0 means that row-level tracking is being used.

  2. At the Publisher on the publication database, execute sp_changemergearticle. Specify a value of column_tracking for @property and one of the following values for @value:

    • true - Use column-level tracking for the article.
    • false - Use row-level tracking, which is the default.

    Specify a value of 1 for both @force_invalidate_snapshot and @force_reinit_subscription.

請參閱

工作

How to: Define a Logical Record Relationship Between Merge Table Articles (Replication Transact-SQL Programming)

其他資源

進階合併式複寫衝突偵測與解決
偵測和解決邏輯記錄中的衝突

說明及資訊

取得 SQL Server 2005 協助