Compartilhar via

  • Artigo

Propriedade AutoClose

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 (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
<DisplayNameKeyAttribute("Database_AutoCloseName")> _
<DisplayDescriptionKeyAttribute("Database_AutoCloseDesc")> _
Property AutoClose As Boolean
    Get
    Set
'Uso
Dim instance As IDatabaseOptions
Dim value As Boolean

value = instance.AutoClose

instance.AutoClose = value

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

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

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

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

Valor da propriedade

Tipo: 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.
If False (default), the server maintains the database in an open and ready state regardless of user activity.

Comentários

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