UserOptions.CursorCloseOnCommit UserOptions.CursorCloseOnCommit UserOptions.CursorCloseOnCommit Property

Definition

Gets or sets the Boolean property value that specifies whether any open cursors are closed when a transaction is committed or rolled back.

public:
 property bool CursorCloseOnCommit { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Deploy, "false")]
public bool CursorCloseOnCommit { get; set; }
Public Property CursorCloseOnCommit As Boolean
Property Value

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.

Examples

Configuring SQL Server in SMO

Remarks

This property overrides the CloseCursorsOnCommitEnabled property of the DatabaseOptions object setting.

Applies to