Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DatabaseOptions.CloseCursorsOnCommitEnabled Property

Gets or sets a Boolean property value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Matrix)]
public bool CloseCursorsOnCommitEnabled { get; set; }

Property Value

Type: Boolean
A Boolean value that specifies whether the CURSOR_CLOSE_ON_COMMIT database option is active.If True, the cursor is closed when a transaction commits. Otherwise, False (default).

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.

Community Additions

Show:
© 2015 Microsoft