![COMMAND_DELIMITER option [DBISQL]](arrow-right.gif){kind=icon}
Controls closing of cursors at the end of a transaction.
ON
ON
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.
