Jaa


ScriptingOptions.OptimizerData Property

Gets or sets the Boolean property value that specifies whether script optimizer data for the referenced objects are included in the generated script.

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

Syntax

'Declaration
Public Property OptimizerData As Boolean
public bool OptimizerData { get; set; }
public:
property bool OptimizerData {
    bool get ();
    void set (bool value);
}
/** @property */
public boolean get_OptimizerData ()

/** @property */
public void set_OptimizerData (boolean value)
public function get OptimizerData () : boolean

public function set OptimizerData (value : boolean)

Property Value

A Boolean value that specifies whether script optimizer data for the referenced objects are included in the generated script. If True, whether script optimizer data for the referenced objects is included in the generated script. If False (default), script optimizer data for the referenced objects is not included in the generated script.

Remarks

This option allows a copy of a database to be created to allow queries to be tuned on a separate system.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

ScriptingOptions Class
ScriptingOptions Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

How to: Script Out the Dependencies for a Database in Visual Basic .NET
Scripting