Online Documentation for SQL Manager for SQL server
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.
Cursor default (CURSOR_DEFAULT)
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.
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.