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.