ANSI_CLOSE_CURSORS_ON_ROLLBACK option [TSQL]

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

ON

ON

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.