How to: Set the Merging Changes or Check Permissions Option
In this topic, you will learn how to configure the Merging Changes option in Microsoft SQL Server 2005 and the Check Permissions option in Microsoft SQL Server 2000. The Merging Changes option ensures that the Merge Agent has the authority to upload data changes to a Publisher.
To configure the Merging Changes option in SQL Server 2005
On the computer that is running SQL Server, start SQL Server Management Studio: Click Start, point to Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.
In Object Explorer, expand the computer that contains your publication, expand Replication, and then expand Publications.
Right-click your publication name and choose Properties. In the Properties dialog box, select the Articles page.
Select an article, click Article Properties, and then choose Set Properties of Highlighted Table Article. This displays the Article Properties dialog box.
Note
You can also set the properties for the whole publication by selecting Set Properties of All Table Articles.
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.
To configure the Check Permissions option in SQL Server 2000
On the computer that is running SQL Server, start SQL Server Enterprise Manager: Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
In the console tree, expand Microsoft SQL Servers, SQL Server Group, the computer that contains your publication, Databases, and the database you are publishing. Click Publications.
Right-click your publication name, click Properties, and then click Articles.
Click the properties button (...) for the published article you want to configure. This displays the Table Article Properties dialog box.
Click the Merging Changes tab.
Under Check permissions, you can select the INSERT, UPDATE, and DELETE check boxes. When these boxes are selected, 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.
Security
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.
See Also
Concepts
Configuring the Merging Changes Option