SQL Management Studio - avoiding automatic commit

Question

I tried to search for a previous answer but the most similar is on a completely different question.

On TOAD for Oracle when I press F5 on an update I still have to choose if I want to commit or rollback.

On SSMS the commit is automatic.

Can I configure it to the need for an explicit commit?

EDIT

I've found that my question has got an exact response here:

possible duplicate of [How to enable automatic transaction scoping on SQL Server Management Studio?](http://stackoverflow.com/questions/3047676/how-to-enable-automatic-transaction-scoping-on-sql-server-management-studio) — Tim Schmelter, Mar 28 '14 at 16:43
SSMS-Tools-Options: [set implicit transactions](http://tinyurl.com/o3glaku) (image inside) — Tim Schmelter, Mar 28 '14 at 16:47
@TimSchmelter: please answer so that I can mark as accepted. — Revious, Mar 28 '14 at 16:57

score 2 · Accepted Answer · answered Mar 28 '14 at 17:00

2

You can set implicit transactions in SQL-Server Managemenet Studio. Therefore you have to change the default option from off to on here:

Here is an image:

enter image description here

answered Mar 28 '14 at 17:00

Tim Schmelter

score 1 · Answer 2 · edited May 23 '17 at 12:21

1

Put BEGIN TRANSACTION at the top of your script.

Or use SET IMPLICIT_TRANSACTIONS ON (courtesy of How do you set autocommit in an SQL Server session?)

edited May 23 '17 at 12:21

Community

answered Mar 28 '14 at 16:43

StingyJack

2 Answers2