Changes some merge filter properties. This stored procedure is executed at the Publisher on the publication database.
sp_changemergefilter [ @publication= ] 'publication' , [ @article= ] 'article' , [ @filtername= ] 'filtername' , [ @property= ] 'property' , [ @value= ] 'value' [ , [ @force_invalidate_snapshot = ] force_invalidate_snapshot ] [ , [ @force_reinit_subscription = ] force_reinit_subscription ]
sp_changemergefilter is used in merge replication.
Changing the filter on a merge article requires the snapshot, if one exists, to be recreated. This is performed by setting the @force_invalidate_snapshot to 1. Also, if there are subscriptions to this article, the subscriptions need to be reinitialized. This is done by setting the @force_reinit_subscription to 1.
To use logical records, the publication and articles must meet a number of requirements. For more information, see Group Changes to Related Rows with Logical Records.