ScriptingOptions.SetTargetServerVersion Method

Sets the version of the instance of SQL Server on which the scripting operation is run.

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

Syntax

'Declaration
Public Sub SetTargetServerVersion ( _
    ver As ServerVersion _
)
'Usage
Dim instance As ScriptingOptions 
Dim ver As ServerVersion

instance.SetTargetServerVersion(ver)

public void SetTargetServerVersion(
    ServerVersion ver
)

public:
void SetTargetServerVersion(
    ServerVersion^ ver
)

member SetTargetServerVersion : 
        ver:ServerVersion -> unit

public function SetTargetServerVersion(
    ver : ServerVersion
)

Parameters

• ver
  Type: Microsoft.SqlServer.Management.Common.ServerVersion
  A ServerVersion object value that specifies the version of the instance of SQL Server.

Examples

The following code example sets the version number of the server upon which the script will run.

Visual Basic

Dim scOps As New ScriptingOptions()
Dim sVersion As New ServerVersion(2, 0)
scOps.SetTargetServerVersion(sVersion)

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$sVersion = New-Object Microsoft.SqlServer.Management.Common.ServerVersion(2,0)
$scOps.SetTargetServerVersion($sVersion)

See Also

Reference

ScriptingOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Scripting