For a given parameter, CURSOR_STATUS shows whether or not a cursor declaration has returned a cursor and result set. 1 The cursor result set has at least one row. For insensitive and keyset cursors, ...

Controls the behavior of the [!INCLUDEtsql] COMMIT TRANSACTION statement. The default value for this setting is OFF. This means that the server will not close cursors when you commit a transaction.