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

Database.CloseCursorsOnCommitEnabled Property

Gets or sets a 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.SqlAzureDatabase|SfcPropertyFlags.Deploy|SfcPropertyFlags.Matrix)]
public bool CloseCursorsOnCommitEnabled { get; set; }

Property Value

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

Implements

IDatabaseOptions.CloseCursorsOnCommitEnabled

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