2

How can I disable the Autocommit Mode in SSMS?
I don't want it to save it all to make the transaction more sure. If the transaction is successful, it will complete and if it's not, it will fail for sure.

I think by default it's on in SSMS...

zx485
  • 28,498
  • 28
  • 50
  • 59
MasterKas
  • 87
  • 1
  • 7

1 Answers1

3

Connect to SQL Server using SSMS

From the Menu bar, select Tools –> Options

Select Query Execution –> SQL Server –> ANSI

Make sure that you check the check box SET IMPLICIT_TRANSACTIONS

Click on OK

Saubhagya Srivastava
  • 174
  • 1
  • 11