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.