Export (0) Print
Expand All
Expand Minimize

ScriptingOptions.TargetServerVersion Property

Gets or sets the version of the instance of SQL Server for which the generated script is intended.

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

public SqlServerVersion TargetServerVersion { get; set; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.SqlServerVersion
A SqlServerVersion object value that specifies the version of the instance of SQL Server.

The default value of this property is Version80.

The following code example specifies that the script owner will be listed in the generated script.

Visual Basic

Dim scOps As New ScriptingOptions()
scOps.TargetServerVersion = SqlServerVersion.Version100

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.TargetServerVersion = [Microsoft.SqlServer.Management.Smo.SqlServerVersion]::Version100

Community Additions

ADD
Show:
© 2014 Microsoft