IDatabaseOptions.AutoClose 屬性
Gets or sets a Boolean property value that specifies whether the AUTOCLOSE database option is active.
命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<DisplayNameKeyAttribute("Database_AutoCloseName")> _
<DisplayDescriptionKeyAttribute("Database_AutoCloseDesc")> _
Property AutoClose As Boolean
Get
Set
'用途
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)
屬性值
型別：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.
範例
How to Get and Set a Property in Visual Basic .NET
請參閱
參考
Microsoft.SqlServer.Management.Smo 命名空間