Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Validate Subscriber Information, Create Publication Wizard

SQL Server 2000

With merge replication dynamic filters, you use a function that references Subscriber information. Microsoft® SQL Server™ 2000 validates Subscriber information based on that function before each merge. This ensures that information is partitioned consistently with each merge.

For example, when a publication is dynamically filtered using the function SUSER_SNAME(), the Merge Agent applies the initial snapshot to each Subscriber based on data that is valid for the SUSER_SNAME() expression.

When the Subscriber reconnects to the Publisher for the next synchronization, the Merge Agent validates the information at the Subscriber and ensures that the same partitions are synchronized as were originally sent as part of the initial snapshot.

Select Yes, validate Subscriber information if you want the Subscriber information to be validated during each merge. Then enter all functions used in dynamic filters for this publication.

Select No, do not validate Subscriber information if you do not want the Subscriber information validated during each merge.

After you create the publication, you cannot change this property in the Publication Properties dialog box.

See Also

Validate Subscriber Information

© 2015 Microsoft