Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Drops a merge filter.
sp_dropmergefilter drops all the merge filter columns defined on the merge filter that is to be dropped. This stored procedure is executed at the Publisher on the publication database.
Transact-SQL Syntax Conventions
sp_dropmergefilter [ @publication= ] 'publication', [ @article= ] 'article' , [ @filtername= ] 'filtername'
[ , [ @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 name of the filter to be dropped.
filtername is sysname, with no default.
@force_invalidate_snapshot= ] force_invalidate_snapshot
Enables or disables the ability to have a snapshot invalidated.
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.
1 means that changes to the merge article may cause the snapshot to be invalid. If that is the case, a value of 1 gives permission for the new snapshot to occur.
@force_reinit_subscription= ] force_reinit_subscription
Enables or disables the ability to mark a subscription as not valid.
force_reinit_subscription is a bit, with a default 0.
0 specifies that changes to the merge article filter do not cause the subscriptions to be invalid.
1 means that changes to the merge article filter causes the subscriptions to be invalid.
0 (success) or 1 (failure)
sp_dropmergefilter is used in merge replication.
Only members of the
sysadmin fixed server role or the db_owner fixed database role can execute sp_dropmergefilter.