Specify Runtime SET Options
You can set AutoCommit behavior on the
Options dialog under the Query Execution heading, Advanced page—see
Query Execution Options (Options Dialog). If no option is set, server-side defaults are applied. If set, the options are mutually exclusive.
To set AutoCommit behavior
1. Click Home, Options to open the Options dialog.
2. Click the triangle at the left of the Query Execution heading, then click the Advanced heading.
3. Specify either SET AUTOCOMMIT ON or SET AUTOCOMMIT OFF.
4. Specify whether you want to generate a Query Execution Plan.
5. Click OK.
The change will take effect immediately.