CLOSE_ON_ENDTRANS option [TSQL]

Function

Controls closing of cursors at the end of a transaction.

Allowed values

ON

Default

ON

Description

When CLOSE_ON_ENDTRANS is set to ON (the default and only value allowed), cursors are closed at the end of a transaction. With this option set ON, it provides Transact-SQL compatible behavior.