Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
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.