As we know that,by default SQL Server Management Studio is in a Autocommit mode,which means whenever we run any transaction and execute then that transaction is committed by default.
If we want to disable Auto commit mode in SQL Server Management Studio or SSMS,then we have to follow below steps:-
1).Connect to SQL Server using SSMS
2).From the Menu bar, select Tools –> Options
3).Select Query Execution –> SQL Server –> ANSI
4).Make sure that you check the check box SET IMPLICIT_TRANSACTIONS
5).Click on OK
Now, open a new Query window and start executing the scripts.
Asked In: Many Interviews |