CLOSE_ON_ENDTRANS Option [TSQL]

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, which is Transact-SQL compatible behavior.