Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad World
Toad for SQL Server
Help

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Work with Data > Commit and Rollback Changes

Commit and Roll Back Changes

If you have tabs or windows open for other connections, commits and rollbacks for those connections are not applied to the current connection nor are they applied to the other connections.

To commit or roll back changes

Click

on the status bar.

Tips:

You can enable or disable auto commit for the current connection by selecting the drop-down on the status bar:
You can specify a global option to enable or disable auto commit by default in Tools | Options | Database | General.
The auto commit option does not affect the DOE (Dialog Object Editor), it applies to Editor only.