Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the Boolean property value that specifies whether any open cursors are closed when a transaction is committed or rolled back.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy, _
"false")> _
Public Property CursorCloseOnCommit As Boolean
Get
Set
'Usage
Dim instance As UserOptions
Dim value As Boolean
value = instance.CursorCloseOnCommit
instance.CursorCloseOnCommit = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy,
"false")]
public bool CursorCloseOnCommit { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy,
L"false")]
public:
property bool CursorCloseOnCommit {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy,
"false")>]
member CursorCloseOnCommit : bool with get, set
function get CursorCloseOnCommit () : boolean
function set CursorCloseOnCommit (value : boolean)
Property Value
Type: System.Boolean
A Boolean value that specifies the whether any open cursors are closed when a transaction is committed or rolled back.If True, open cursors are closed when a transaction is committed or rolled back.If False (default), open cursors are not closed when a transaction is committed or rolled back.
Remarks
This property overrides the CloseCursorsOnCommitEnabled property of the DatabaseOptions object setting.
Examples
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace