Export (0) Print
Expand All
Expand Minimize

sp_changemergefilter (Transact-SQL)

Changes some merge filter properties. This stored procedure is executed at the Publisher on the publication database.

Topic link icon Transact-SQL Syntax Conventions


sp_changemergefilter [ @publication= ] 'publication'
        , [ @article= ] 'article'
        , [ @filtername= ] 'filtername'
        , [ @property= ] 'property'
        , [ @value= ] 'value'
    [ , [ @force_invalidate_snapshot = ] force_invalidate_snapshot ]
    [ , [ @force_reinit_subscription = ] force_reinit_subscription ]

[ @publication= ] 'publication'

Is the name of the publication. publication is sysname, with no default.

[ @article= ] 'article'

Is the name of the article. article is sysname, with no default.

[ @filtername= ] 'filtername'

Is the current name of the filter. filtername is sysname, with no default.

[ @property= ] 'property'

Is the name of the property to change. property is sysname, with no default.

[ @value=] 'value'

Is the new value for the specified property. valueis nvarchar(1000), with no default.

This table describes the properties of articles and the values for those properties.

Property

Value

Description

filter_type

1

Join filter.

This option is required to support SQL Server Compact 3.5 SP2 Subscribers.

 

2

Logical record relationship.

 

3

Join filter is also a logical record relationship.

filtername

 

Name of the filter.

join_articlename

 

Name of the join article.

join_filterclause

 

Filter clause.

join_unique_key

true

Join is on a unique key

 

false

Join is not on a unique key.

[ @force_invalidate_snapshot = ] force_invalidate_snapshot

Acknowledges that the action taken by this stored procedure may invalidate an existing snapshot. force_invalidate_snapshot is a bit, with a default 0.

0 specifies that changes to the merge article do not cause the snapshot to be invalid. If the stored procedure detects that the change does require a new snapshot, an error occurs and no changes are made.

1 means that changes to the merge article may cause the snapshot to be invalid, and if there are existing subscriptions that would require a new snapshot, gives permission for the existing snapshot to be marked as obsolete and a new snapshot generated.

[ @force_reinit_subscription = ] force_reinit_subscription

Acknowledges that the action taken by this stored procedure may require existing subscriptions to be reinitialized. force_reinit_subscription is a bit with a default of 0.

0 specifies that changes to the merge article do not cause the subscription to be reinitialized. If the stored procedure detects that the change would require existing subscriptions to be reinitialized, an error occurs and no changes are made.

1 means that changes to the merge article will cause existing subscriptions to be reinitialized, and gives permission for the subscription reinitialization to occur.

0 (success) or 1 (failure)

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 Grouping Changes to Related Rows with Logical Records.

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_changemergefilter.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft