Configuring the Merging Changes Option
You can use the Merging Changes option (Check Permissions in Microsoft SQL Server 2000) to provide an enhanced level of security to your publication. The Merging Changes option ensures that the Merge Agent has the authority to upload data changes to a Publisher. When you specify this option, SQL Server verifies that the Merge Agent logon has the permissions to perform INSERT, UPDATE, and DELETE statements on the publication database.
Setting Merging Changes Option
Using Merging Changes is optional. When you specify Merging Changes, both Merging Changes validation and PAL verification are performed.
Important
If you set the Merging Changes option after the initial snapshot has been generated, a new snapshot must be generated and reapplied at the Subscriber for permissions to be validated when data changes are merged.
To configure the Merging Changes option in SQL Server 2005 or the Check Permissions option in SQL Server 2000, see How to: Set the Merging Changes or Check Permissions Option.
If you specify Merging Changes or Check Permissions, you must grant database access based on how you configured Microsoft Internet Information Services (IIS) and SQL Server Authentication. For more information, see Granting Access to the Database and Publication.
See Also
Concepts
Securing the Publication
Granting Access to the Database and Publication