ANSI_CLOSE_CURSORS_ON_ROLLBACK Option [TSQL]

Controls whether cursors that were opened WITH HOLD are closed when a ROLLBACK is performed.

Allowed Values

ON

Default

ON

Description

The ANSI SQL/3 standard requires all cursors be closed when a transaction is rolled back. This option forces that behavior and cannot be changed. The CLOSE_ON_ENDTRANS option overrides this option.