How to: Specify a Merge Article Resolver (SQL Server Management Studio)

Merge replication allows the following types of article resolvers:

  • The default resolver. The behavior of the default resolver depends on whether the subscription is a client subscription or a server subscription. For more information about specifying subscription type, see How to: Specify a Merge Subscription Type and Conflict Resolution Priority (SQL Server Management Studio).

  • A custom resolver you have written, which can be a business logic handler (written in managed code) or a custom COM-based resolver.

  • A standard COM-based resolver, which is included with Microsoft SQL Server.

To use a resolver other than the default resolver, you must copy the resolver to the computer on which the Merge Agent runs and register it (if you are using a business logic handler, it must also be registered at the Publisher). The Merge Agent runs at:

  • The Distributor for a push subscription

  • The Subscriber for a pull subscription

  • The Microsoft Internet Information Services (IIS) server for a pull subscription that uses Web synchronization

For more information on registering a resolver, see How to: Specify a Merge Article Resolver (Replication Transact-SQL Programming).

After the resolver is registered, specify that an article should use the resolver on the Resolver tab of the Article Properties - <Article> dialog box, which is available in the New Publication Wizard and the Publication Properties - <Publication> dialog box. For more information about using the wizard and accessing the dialog box, see How to: Create a Publication and Define Articles (SQL Server Management Studio) and How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

To specify a resolver

  1. On the Articles page of the New Publication Wizard or the Publication Properties - <Publication> dialog box, select a table.

  2. Click Article Properties, and then click Set Properties of Highlighted Table Article.

  3. On the Article Properties - <Article> page, click the Resolver tab.

  4. Select Use a custom resolver (registered at the Distributor), and then in the list, click the resolver.

  5. If the resolver requires input (such as a column name), specify it in the Enter information needed by the resolver text box.

  6. Click OK.

  7. Repeat this process for each article that requires a resolver.