MergeArticle.ChangeMergeJoinFilter Method

Article
12/03/2008

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 _
)

public void ChangeMergeJoinFilter (
    MergeJoinFilter oldJoinFilter,
    MergeJoinFilter newJoinFilter
)

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

public void ChangeMergeJoinFilter (
    MergeJoinFilter oldJoinFilter, 
    MergeJoinFilter newJoinFilter
)

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

Parameters

oldJoinFilter
A MergeJoinFilter value that specifies the old filter.

newJoinFilter
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.

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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via