Expand Minimize
This topic has not yet been rated - Rate this topic

IDatabaseOptions.AutoClose Property

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)
[DisplayNameKeyAttribute("Database_AutoCloseName")]
[DisplayDescriptionKeyAttribute("Database_AutoCloseDesc")]
bool AutoClose { get; set; }

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

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.