Other Microsoft Resolvers

SQL Replication

Replication

Other Microsoft Resolvers

When conflicts occur during the merge process, a conflict resolver must determine how the conflict is resolved. Microsoft® SQL Server™ 2000 includes several custom COM-component resolvers that can be used for this purpose, in addition to the default priority-based resolver and the stored procedure resolver:

  • Microsoft SQL Server Additive Conflict Resolver

  • Microsoft SQL Server Averaging Conflict Resolver

  • Microsoft SQL Server DATETIME (Earlier Wins) Conflict Resolver

  • Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver

  • Microsoft SQL Server Maximum Conflict Resolver

  • Microsoft SQL Server Merge Text Conflict Resolver

  • Microsoft SQL Server Minimum Conflict Resolver

  • Microsoft SQL Server Subscriber Always Wins Conflict Resolver

The resolvers are installed during the installation process for SQL Server 2000. The sp_enumcustomresolvers stored procedure can be used to view all the conflict resolvers registered on that computer. In SQL Query Analyzer, run:

exec sp_enumcustomresolvers

This displays the description and globally unique identifier (GUID) for each resolver in a separate result set.

The resolver must be registered on the computer from which the Merge Agent is invoked. For push subscriptions, the resolver is registered at the Distributor. For pull subscriptions, the resolver should be registered at the Subscriber.