Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Microsoft SQL Server replication provides an Interactive Resolver, which you can use to resolve conflicts manually during on-demand synchronization in Microsoft Windows Synchronization Manager. When you activate it at run time, the Interactive Resolver provides a graphical interface that displays data for each conflicting row. It offers options for viewing and editing the conflict data, and resolving each conflict individually.
The Interactive Resolver resembles the Conflict Viewer. However, the Conflict Viewer displays the results of conflicts that are already resolved after merge synchronization. The Interactive Resolver displays each conflict prior to resolution, so you can determine the outcome of each conflict during merge synchronization. Someone should be available to monitor the Interactive Resolver when a conflict occurs.
Note
Interactive Resolution requires Windows Synchronization Manager. If you perform a synchronization outside of Windows Synchronization Manager (as a scheduled synchronization or an on demand synchronization in SQL Server Management Studio or Replication Monitor), the system resolves conflicts automatically without user intervention, according to the resolver specified for the article. The Interactive Resolver doesn't display conflicts that involve logical records. To view information about these conflicts, use replication stored procedures. For more information, see View Conflict Information for Merge Publications (Replication Transact-SQL Programming).
Article resolvers and the Interactive Resolver
When you create a publication, you assign conflict resolvers (either the default resolver, a business logic handler, or a custom resolver) to specific articles. They use a set of rules to determine which set of data to use when conflicting row data is entered. The Interactive Resolver isn't a separate conflict resolver with rules for determining conflict winners and losers, but a tool used in conjunction with default and custom resolvers. The article resolver still determines the winning and losing row, but the Interactive Resolver allows user intervention to accept, reject, or modify the results.
To use the Interactive Resolver, you must enable interactive resolution for each article and subscription that requires it. After you enable it for one or more articles and subscriptions, the Interactive Resolver is used when a conflict is detected during merge synchronization.
To use the Interactive Resolver, see Specify Merge Replication options and Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager).