A savepoint is a special mark inside a transaction that allows all commands that are executed after it is established to be rolled back, restoring the transaction state to what it was at the time of the savepoint. Query Design Center enables you to create savepoints for transactions you perform.
| Note: | You can only create a savepoint when manual commit mode is enabled. |
Perform the following steps to create a savepoint:
-
On the Options menu, click Manual Commit Mode.
A check mark appears to the left of the command to indicate that manual commit mode is enabled.
-
Perform the desired actions.
-
Right-click the Analyze Query window, and click Savepoint.
The New Savepoint dialog box appears.
-
Type the desired name in the Savepoint Name box, and click OK.
A message is displayed indicating that the savepoint was successfully created.
