MergeArticle.ChangeMergeJoinFilter Method

Changes a join filter that defined on a merge article.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Sub ChangeMergeJoinFilter ( _
    oldJoinFilter As MergeJoinFilter, _
    newJoinFilter As MergeJoinFilter _
)
'Usage
Dim instance As MergeArticle 
Dim oldJoinFilter As MergeJoinFilter 
Dim newJoinFilter As MergeJoinFilter

instance.ChangeMergeJoinFilter(oldJoinFilter, _
    newJoinFilter)

public void ChangeMergeJoinFilter(
    MergeJoinFilter oldJoinFilter,
    MergeJoinFilter newJoinFilter
)

public:
void ChangeMergeJoinFilter(
    MergeJoinFilter^ oldJoinFilter, 
    MergeJoinFilter^ newJoinFilter
)

member ChangeMergeJoinFilter : 
        oldJoinFilter:MergeJoinFilter * 
        newJoinFilter:MergeJoinFilter -> unit

public function ChangeMergeJoinFilter(
    oldJoinFilter : MergeJoinFilter, 
    newJoinFilter : MergeJoinFilter
)

Parameters

• oldJoinFilter
  Type: Microsoft.SqlServer.Replication.MergeJoinFilter
  A MergeJoinFilter value that specifies the old filter.

• newJoinFilter
  Type: Microsoft.SqlServer.Replication.MergeJoinFilter
  A MergeJoinFilter value that specifies the new filter.

Remarks

Calling the ChangeMergeJoinFilter method is equivalent to executing sp_changemergefilter (Transact-SQL).

The ChangeMergeJoinFilter method can only be called by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

See Also

Reference

MergeArticle Class

Microsoft.SqlServer.Replication Namespace