• Article

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

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.

This ChangeMergeJoinFilter method is only available when working with instances of Microsoft SQL Server 2000 and Microsoft SQL Server 2005.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.