How to: Specify a Merge Subscription Type and Conflict Resolution Priority (SQL Server Management Studio)

Specify a merge subscription type and conflict resolution priority on the Subscription Type page of the New Subscription Wizard. For more information about using this wizard, see How to: Create a Push Subscription (SQL Server Management Studio) and How to: Create a Push Subscription (SQL Server Management Studio).

Subscription type cannot be modified after a subscription is created, but priority can be modified for the server subscription type in the Subscription Properties - <Publisher>: <PublicationDatabase> dialog box. For more information about accessing this dialog box, see How to: View and Modify Push Subscription Properties (SQL Server Management Studio) and How to: View and Modify Pull Subscription Properties (SQL Server Management Studio).

To specify a merge subscription type and conflict resolution priority

  1. On the Subscription Type page of the New Subscription Wizard, select Client or Server for the Subscription Type option.

  2. If you select a subscription type of Server, also enter a value (0.00 to 99.99) for the Priority for Conflict Resolution option.

To modify the conflict resolution priority

  1. In the Subscription Properties - <Publisher>: <PublicationDatabase> at the Publisher, enter a value (0.00 to 99.99) for the Priority option.

  2. Click OK.

See Also

Concepts

Advanced Merge Replication Conflict Detection and Resolution
Subscribing to Publications

Other Resources

How to: Create a Pull Subscription (Replication Transact-SQL Programming)
How to: Create a Push Subscription (Replication Transact-SQL Programming)
How to: View and Modify Pull Subscription Properties (Replication Transact-SQL Programming)
How to: View and Modify Push Subscription Properties (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance