Export (0) Print
Expand All

UserOptions.CursorCloseOnCommit Property

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)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy|SfcPropertyFlags.Matrix, 
	"false")]
public bool CursorCloseOnCommit { get; set; }

Property Value

Type: 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.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft