sp_dropmergefilter (T-SQL)

Drops a merge filter. sp_dropmergefilter drops all the merge filter columns defined on the merge filter that is to be dropped.

Syntax

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

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.

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