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 Property TargetServerVersion As SqlServerVersion

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


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