SQL08: How to disable autocommit in SQL Server Management Studio

You have you ever wondered how to disable autocommit in Sql Server Management Studio? The answer is quick. What you can change the menu selecting Tools> Options> Execution of the query> SQL Server> Ansi> SET IMPLICIT_TRANSACTIONS.

 

 

It seems rather simple but as I have been asked a couple of times ...

 

I have been wondering how to

I have been wondering how to disable autocommit in Sql dedicated server Management Studio for awhile now. I didn't realize that it was so simple to do. Thanks for providing the directions on how to do this. I've spent hours at a time trying to figure this out. I was definitely making it a lot harder than it was!

Post new comment

The content of this field is kept private and will not be shown publicly.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.
Google