DatabaseOptions Class

The DatabaseOptions object represents a Microsoft SQL Server database options.

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

Syntax

'Declaration
Public NotInheritable Class DatabaseOptions
    Inherits SqlSmoObject
    Implements IAlterable
public sealed class DatabaseOptions : SqlSmoObject, IAlterable
public ref class DatabaseOptions sealed : public SqlSmoObject, IAlterable
public final class DatabaseOptions extends SqlSmoObject implements IAlterable
public final class DatabaseOptions extends SqlSmoObject implements IAlterable

Remarks

Updated text:

Updated text:

Configurable database options, such as ANSI settings, cursor settings, arithmetic behavior, recovery model, and the read-only status, are contained in the DatabaseOptions object. The DatabaseOptions object is a child of the Database object.

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

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Management.Smo.SmoObjectBase
     Microsoft.SqlServer.Management.Smo.SqlSmoObject
      Microsoft.SqlServer.Management.Smo.DatabaseOptions

Example

How to: Get and Set a Property in Visual Basic .NET

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

DatabaseOptions Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Setting Properties
Database Options

Change History

Release

History

New content:
  • Added text stating that the AutoShrink property is equivalent to setting the db_option autoshrink option in Transact-SQL.

New content:
  • Added the IsParameterizationForced property.