• Article

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

'Declaration
Public Property TargetServerVersion As SqlServerVersion
    Get
    Set
'Usage
Dim instance As ScriptingOptions
Dim value As SqlServerVersion

value = instance.TargetServerVersion

instance.TargetServerVersion = value

public SqlServerVersion TargetServerVersion { get; set; }

public:
property SqlServerVersion TargetServerVersion {
    SqlServerVersion get ();
    void set (SqlServerVersion value);
}

member TargetServerVersion : SqlServerVersion with get, set

function get TargetServerVersion () : SqlServerVersion
function set TargetServerVersion (value : SqlServerVersion)

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

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