This topic has not yet been rated - Rate this topic

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)

Syntax

C++

JScript

Copy


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.

Remarks

The default value of this property is Version80.

Examples

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

Visual Basic

Copy

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

PowerShell

Copy

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

Reference

ScriptingOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Scripting

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ