article Properties, Merging Changes Tab
SQL Server™ 2000 provides the option to validate permissions for a Subscriber to upload data changes to a Publisher. This verifies that the Merge Agent login has the permissions to perform INSERT, UPDATE, and DELETE commands on the publication database. Validating permissions requires that the Merge Agent login be a valid user with the appropriate permissions in the publication database.
This permissions validation is in addition to the verification that the logins used at the Subscriber are in the publication access list (PAL).
If you set the check permissions option after the initial snapshot has been generated, a new snapshot must be generated and reapplied at the Subscriber in order for permissions to be validated when data changes are merged.
The following options are available on the Merging Changes tab of the article Properties dialog box.
Select to have SQL Server verify that the Merge Agent login has permissions to perform INSERT commands.
Select to have SQL Server verify that the Merge Agent login has permissions to perform UPDATE commands.
Select to have SQL Server verify that the Merge Agent login has permissions to perform DELETE commands.
Enables SQL Server to generate one UPDATE statement for all changes to multiple column values in the same row. If you open the article properties, Merging Changes tab while in the Create Publication Wizard, you can modify this option. If you open the article properties, Merging Changes tab while in the Publication Properties after the publication is created, you will be able to view this option, but you will not be able to modify it.