MergePublication.ScriptMergePartition Method

Generates a Transact-SQL script that can be used to re-create a Subscriber partition for publications with a parameterized row filter.

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

Syntax

'Declaration
Public Function ScriptMergePartition ( _
    mergePartition As MergePartition, _
    scriptOption As ScriptOptions _
) As String
'Usage
Dim instance As MergePublication 
Dim mergePartition As MergePartition 
Dim scriptOption As ScriptOptions 
Dim returnValue As String 

returnValue = instance.ScriptMergePartition(mergePartition, _
    scriptOption)

public string ScriptMergePartition(
    MergePartition mergePartition,
    ScriptOptions scriptOption
)

public:
String^ ScriptMergePartition(
    MergePartition^ mergePartition, 
    ScriptOptions scriptOption
)

member ScriptMergePartition : 
        mergePartition:MergePartition * 
        scriptOption:ScriptOptions -> string

public function ScriptMergePartition(
    mergePartition : MergePartition, 
    scriptOption : ScriptOptions
) : String

Parameters

• mergePartition
  Type: Microsoft.SqlServer.Replication.MergePartition
  The merge partition to be scripted.

• scriptOption
  Type: Microsoft.SqlServer.Replication.ScriptOptions
  The scripting options.

Return Value

Type: System.String
The Transact-SQL script.

Remarks

The ScriptMergePartition 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

MergePublication Class

Microsoft.SqlServer.Replication Namespace