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.SqlAzureDatabase | SfcPropertyFlags.Deploy, 
	"false")]
public bool CursorCloseOnCommit { get; set; }

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.

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

Return to top
Show: