SQL Server prevents Management Studio from Autocommit transactions _mssql

Auto COMMIT Transaction

The default Management Studio is autocommit transactions, that is, a statement on a transaction.

An implicit transaction

Open SQL Server managerment Studio and log into the instance.
Tools-> Options
Query Execution-> SQL Server-> ANSI

Tick the set implicit_transactions front
Thus, when a transaction ends, the new statement automatically opens a new transaction. This is an implicit transaction. The end of the transaction is also through our commit or rollback.

An explicit transaction

BEGIN TRANSACTION
Delete from Erpdb.dbo.mtl_categories_b
ROLLBACK TRANSACTION
--commit Transaction