Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

article Properties, Merging Changes Tab

SQL Server 2000

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.

Options

INSERT

Select to have SQL Server verify that the Merge Agent login has permissions to perform INSERT commands.

UPDATE

Select to have SQL Server verify that the Merge Agent login has permissions to perform UPDATE commands.

DELETE

Select to have SQL Server verify that the Merge Agent login has permissions to perform DELETE commands.

Multicolumn updates

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.

See Also

Merge Replication

Merge Replication Conflict Detection and Resolution

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.