commit-and-rollback-behavior.md

title	Commit and Rollback Behavior | Microsoft Docs
ms.custom
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	connectivity
ms.reviewer
ms.technology	connectivity
ms.topic	conceptual
helpviewer_keywords	interoperability [ODBC], transaction support transactions [ODBC], DBMS support
ms.assetid	2ac8f012-e46d-41ca-81bb-e4a3246e3241
author	David-Engel
ms.author	v-daenge

Commit and Rollback Behavior

A common behavior among server DBMSs is to close cursors and discard prepared statements when a statement is committed or rolled back. Desktop databases are more likely to keep cursors open and keep prepared statements. For more information, see the SQL_CURSOR_COMMIT_BEHAVIOR and SQL_CURSOR_ROLLBACK_BEHAVIOR options in the SQLGetInfo function description and Effect of Transactions on Cursors and Prepared Statements.