CloseCursorsOnCommitEnabled 속성
CURSOR_CLOSE_ON_COMMIT 데이터베이스 옵션이 활성 상태인지 여부를 지정하는 값을 가져오거나 설정합니다.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Deploy)> _
Public Property CloseCursorsOnCommitEnabled As Boolean
Get
Set
‘사용 방법
Dim instance As Database
Dim value As Boolean
value = instance.CloseCursorsOnCommitEnabled
instance.CloseCursorsOnCommitEnabled = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)]
public bool CloseCursorsOnCommitEnabled { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Deploy)]
public:
virtual property bool CloseCursorsOnCommitEnabled {
bool get () sealed;
void set (bool value) sealed;
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)>]
abstract CloseCursorsOnCommitEnabled : bool with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)>]
override CloseCursorsOnCommitEnabled : bool with get, set
final function get CloseCursorsOnCommitEnabled () : boolean
final function set CloseCursorsOnCommitEnabled (value : boolean)
속성 값
유형: System. . :: . .Boolean
CloseCursorsOnCommitEnabled 데이터베이스 옵션을 설정하는 방법을 지정하는 Boolean 값입니다. True이면 트랜잭션이 커밋될 때 커서가 닫힙니다. False(기본값)이면 트랜잭션이 커밋될 때 커서가 닫히지 않습니다.
구현
주의
This property specifies whether a cursor is closed when a transaction commits. This option can also be changed by using the Transact-SQL ALTER DATABASE statement.