Export (0) Print
Expand All
Expand Minimize

Database.AutoClose Property

Gets or sets a value that specifies whether the AUTOCLOSE database option is set.

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

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Deploy)> _
Public Property AutoClose As Boolean 
	Get 
	Set
'Usage
Dim instance As Database 
Dim value As Boolean 

value = instance.AutoClose

instance.AutoClose = value

Property Value

Type: 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.

Implements

IDatabaseOptions.AutoClose
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft