Online Documentation for SQL Manager for SQL server

Cursor options


CheckBox Close cursor when transaction committed (CURSOR_CLOSE_ON_COMMIT)

When this option is enabled, any open cursors are closed automatically (in compliance with SQL-92) when a transaction is committed. When disabled, cursors remain open across transaction boundaries, closing only when the connection is closed or when they are explicitly closed.

 

Database Properties - Options - Cursor options

 

 

Cursor default (CURSOR_DEFAULT)

RadioButton LOCAL

The scope of the cursor is local to the batch, stored procedure, or trigger in which the cursor was created.The cursor name is valid only within this scope. The cursor can be referenced by local cursor variables in the batch, stored procedure, or trigger, or a stored procedure OUTPUT parameter.

RadioButton GLOBAL

The scope of the cursor is global to the connection. The cursor name can be referenced in any stored procedure or batch executed by the connection.