Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
NoCommandTerminator Property
Collapse the table of content
Expand the table of content

ScriptingOptions.NoCommandTerminator Property

Gets or sets the Boolean property value that specifies whether individual Transact-SQL statements are delimited in the generated script.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

member NoCommandTerminator : bool with get, set

Property Value

Type: Boolean
A Boolean value that specifies whether individual Transact-SQL statements are delimited in the generated script.If True, individual Transact-SQL statements are not delimited in the generated script.If False (default), individual Transact-SQL statements are delimited by using the connection-specific command terminator.

The following code example specifies that individual Transact-SQL statements will not be delimited.

Visual Basic

Dim scOps As New ScriptingOptions()
scOps.NoCommandTerminator = true

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.NoCommandTerminator = $TRUE

Community Additions

ADD
Show:
© 2015 Microsoft