Export (0) Print
Expand All

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)

public void SetTargetServerVersion(
	ServerVersion ver
)

Parameters

ver
Type: ServerVersion
A ServerVersion object value that specifies the version of the instance of SQL Server.

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)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft