• Article

DatabaseOptions Class

The DatabaseOptions object represents SQL Server database options.

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

Syntax

'Declaration
<SfcElementTypeAttribute("Option")> _
Public NotInheritable Class DatabaseOptions _
    Inherits SqlSmoObject _
    Implements IAlterable
'Usage
Dim instance As DatabaseOptions

[SfcElementTypeAttribute("Option")]
public sealed class DatabaseOptions : SqlSmoObject, 
    IAlterable

[SfcElementTypeAttribute(L"Option")]
public ref class DatabaseOptions sealed : public SqlSmoObject, 
    IAlterable

[<SealedAttribute>]
[<SfcElementTypeAttribute("Option")>]
type DatabaseOptions =  
    class
        inherit SqlSmoObject
        interface IAlterable
    end

public final class DatabaseOptions extends SqlSmoObject implements IAlterable

Remarks

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.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.

Thread Safety

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

Inheritance Hierarchy

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

Thread Safety

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