How to: Set the Merging Changes or Check Permissions Option

In this topic, you will learn how to configure the Merging Changes option in SQL Server 2008. The Merging Changes option ensures that the Merge Agent has the authority to upload data changes to a Publisher.

  1. On the computer that is running SQL Server, start SQL Server Management Studio. To do that, click Start, point to Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.

  2. In Object Explorer, expand the computer that contains your publication, expand Replication, and then expand Publications.

  3. Right-click your publication name and choose Properties. In the Properties dialog box, select the Articles page.

  4. Select an article, click Article Properties, and then choose Set Properties of Highlighted Table Article. This displays the Article Properties dialog box.

    You can also set the properties for the whole publication by selecting Set Properties of All Table Articles.

  5. In the Merging Changes section of the properties list, you can set the INSERT, UPDATE, and DELETE permission settings to true or false. When these properties are set to true, SQL Server verifies that the Merge Agent is running under a user identity that has permission to insert, update, or delete data on the Publisher.

When you specify the Check Permissions or Merging Changes option, SQL Server verifies that the Merge Agent logon has the permissions to perform INSERT, UPDATE, and DELETE statements on the publication database.