By default, SSMS is in auto commit mode. To disable it, follow below steps.

  • Connect to SSMS
  • Navigate to Tools > Options > Query Execution > SQL Server > ANSI
  • Check the checkbox against “SET IMPLICIT_TRANSACTIONS“