IDatabasePerformanceFacet.AutoClose Property

Gets or sets a value that indicates whether the database will be closed automatically after the last user exits.

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

Syntax

'Declaration
<DisplayDescriptionKeyAttribute("Database_AutoCloseDesc")> _
<DisplayNameKeyAttribute("Database_AutoCloseName")> _
Property AutoClose As Boolean 
    Get 
    Set
'Usage
Dim instance As IDatabasePerformanceFacet 
Dim value As Boolean 

value = instance.AutoClose

instance.AutoClose = value

[DisplayDescriptionKeyAttribute("Database_AutoCloseDesc")]
[DisplayNameKeyAttribute("Database_AutoCloseName")]
bool AutoClose { get; set; }

[DisplayDescriptionKeyAttribute(L"Database_AutoCloseDesc")]
[DisplayNameKeyAttribute(L"Database_AutoCloseName")]
property bool AutoClose {
    bool get ();
    void set (bool value);
}

[<DisplayDescriptionKeyAttribute("Database_AutoCloseDesc")>]
[<DisplayNameKeyAttribute("Database_AutoCloseName")>]
abstract AutoClose : bool with get, set

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

Property Value

Type: System.Boolean
A Boolean value that indicates whether the database will be closed automatically after the last user exits. Returns True if the database will be closed; otherwise, False.

Remarks

This property corresponds to the AUTO_CLOSE TSQL argument of ALTER DATABASE SET OPTIONS.

See Also

Reference

IDatabasePerformanceFacet Interface

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

ALTER DATABASE SET Options (Transact-SQL)