Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SET CURSOR_CLOSE_ON_COMMIT

SQL Server 2000

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.