AutoClose Property
Collapse the table of content
Expand the table of content

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)

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Deploy)]
public 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.

Return to top
© 2015 Microsoft