SET CURSOR_CLOSE_ON_COMMIT (E-SQL)
The SET CURSOR_CLOSE_ON_COMMIT statement sets all cursors on a connection to automatically close when a COMMIT TRANSACTION or a ROLLBACK TRANSACTION statement is issued.
Syntax
SET CURSOR_CLOSE_ON_COMMIT { ON | OFF };
Arguments
- ON
- Specifies closing all cursors on a connection when a COMMIT TRANSACTION or a ROLLBACK TRANSACTION statement is issued.
- OFF (default)
- Specifies that the calling application is required to close each cursor on a connection when a COMMIT TRANSACTION or a ROLLBACK TRANSACTION statement is issued.
Remarks
You can use the SET CURSOR_CLOSE_ON_COMMIT command for standard and browse cursors.
See Also
(c) 1988-98 Microsoft Corporation. All Rights Reserved.