How to Disable the Autocommit Mode in Sql Server?

 Posted by vishalneeraj-24503 on 12/1/2014 | Category: Sql Server Interview questions | Views: 543 | Points: 40
Answer:

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 | Alert Moderator 

Comments or Responses

Login to post response