Share via

DatabaseOptions.AutoClose Property

  • Article

Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property AutoClose As Boolean 
    Get 
    Set
'Usage
Dim instance As DatabaseOptions 
Dim value As Boolean 

value = instance.AutoClose

instance.AutoClose = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool AutoClose { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool AutoClose {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member AutoClose : bool with get, set

function get AutoClose () : boolean 
function set AutoClose (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the AUTOCLOSE database option is active.If True, the database is closed, and its resources are freed when no user connection accesses the database. Otherwise, False (default).

Remarks

This property specifies whether a database remains open and active when there are no connections.

Examples

Setting Properties

See Also

Reference

DatabaseOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Database Options