Auto commit transaction
The default Management Studio is to automatically commit transactions, that is, one transaction per statement.
Open SQL Server Manager studio and log in to the instance.
Tools -> Options
Query Execution -> SQL Server -> ANSI
Set implicit_ Tick before transactions
In this way, when a transaction ends, a new statement will automatically start a new transaction. This is an implicit transaction. Finally, the transaction ends through our commit or rollback.
delete from erpdb.dbo.mtl_categories_b