Set Queued Updating Conflict Resolution Options (SQL Server Management Studio)

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Set conflict resolution options for publications that support queued updating subscriptions on the Subscription Options page of the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see View and Modify Publication Properties.

To set queued updating conflict resolution options

  1. On the Subscription Options page of the Publication Properties - <Publication> dialog box, select one of the following values for the Conflict resolution policy option:

    • Keep the Publisher change

    • Keep the Subscriber change

    • Reinitialize the subscription

  2. Click OK.

See Also

Enable Updating Subscriptions for Transactional Publications
Queued Updating Conflict Detection and Resolution