sp_changemergefilter (T-SQL)

Changes some merge filter properties. The merge filter properties that can be changed include filtername and join_filterclause.

Syntax

sp_changemergefilter [@publication =] 'publication', [@article =]'article'
    [@filtername =] 'filtername', [@property =] 'property',
    [@value =]    'value'

Argument

[@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. filtername is sysname, with no default. The filter is a WHERE clause without the WHERE keyword.

[@property =] 'property'

Is the name of the property to change. property is sysname, with no default, and can be one of these values.

 

Value	Description
filtername	Name of the filter
join_filterclause	Filter clause
join_articlename	Name of the join article

[@value =] 'value'

Is the new value for the specified property. value is nvarchar(2000), with no default.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_changemergefilter is used in merge replication.

Add a new merge filter if you want to change the join table.

Permissions

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

See Also