Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

ScriptingOptions.BatchSize Property

Gets or sets the number of statements after which to script batch terminator.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public int BatchSize { get; set; }

Property Value

Type: System.Int32
A Int32 value that indicates the number of insert statements that are scripted before a batch terminator is inserted.

The default for this property is 1.

The following code example sets the scripts batch size to 10.

Visual Basic

Dim scOps As New ScriptingOptions()
scOps.BatchSize = 10

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.BatchSize = 10
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.