Microsoft KB Archive/300080

= BUG: Property Changes in the Merging Changes Tab of an Indexed View Article Are Not Saved =

Article ID: 300080

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition

-



This article was previously published under Q300080



BUG #: 354091 (SHILOH_BUGS)



SYMPTOMS
Indexed views are views whose results are persisted in the database and indexed for fast access. After the indexed views are created, you can publish the views as articles in Replication. If indexed views are part of a merge publication, changes to the Merging Changes tab of an indexed view article's properties are not saved.



CAUSE
The Merging Changes tab does not apply to indexed view articles because the articles are published as indexed views at the Subscriber. You cannot set the Merging Changes property for indexed views so you cannot save any change made to the Merging Changes tab.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.



Steps to Reproduce Behavior

 * 1) Publish an indexed view as an article in a merge publication.
 * 2) Open the Article Properties dialog box for the article you created in step 1.
 * 3) Click the Merging Changes tab.
 * 4) On the Merging Changes tab, select the Insert, Update and Delete check boxes.
 * 5) Click OK to save the changes.
 * 6) Open the Article Properties dialog box again and note that the changes you made on the Merging Changes tab are not saved

The following excerpt is from the &quot;article Properties, Merging Changes Tab&quot; topic in SQL Server 2000 Books Online:

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.

Keywords: kbbug kbpending KB300080

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.