SET CURSOR_CLOSE_ON_COMMIT

Controls the behavior of the Transact-SQL 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.

Syntax

SET CURSOR_CLOSE_ON_COMMIT { ON | OFF }  [;]

Remarks

Argument values are ignored and do not change the default behavior.

Permissions

Requires membership in the public role.

See Also