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 ]
[@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 will not cause the snapshot to be invalid. 1 means that changes to the merge article may cause the snapshot to be invalid, and if that is the case, a value of 1 gives permission for the new snapshot to occur.
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.