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
CLOSE SET ANSI_DEFAULTS
OPEN  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.