sp_dropmergefilter

Transact-SQL Reference

Transact-SQL Reference

sp_dropmergefilter

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.

Syntax

sp_dropmergefilter [ @publication = ] 'publication
    ,
[ @article = ] 'article'
    ,
[ @filtername = ] 'filtername'
    [ , [ @force_invalidate_snapshot = ] force_invalidate_snapshot ]

Arguments

[@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.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_dropmergefilter is used in merge replication.

Permissions

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

See Also

sp_addmergefilter

sp_changemergefilter

sp_helpmergefilter

System Stored Procedures