How can I disable autocommit to Table design page in SSMS?

Question

Hello, I want to disable autocommit to table design page.

I disabled autocommit by cheking

'Tools->Options->Query Execution->SQL Server ->ANSI->SET IMPLICIT_TRANSACTIONS'

So I checked alter query affected after executing commit query.

But, in design page, It seems to be autocommited when I add column and save.

(because I using some program blocked commit query, and make some decide.

but when I change columns in design page, commit is blocked, but change is affected.)

How can i disable autocommit in design page?

Answer 1

Hello @Danny jeong,

 When you change the table structure in design page , ‘save’ option is like ‘commit’ in query. You commit the transaction when you click ‘save ‘option. 

Check ‘SET IMPLICIT_TRANSACTIONS’ option to disable auto commit in SQL server, you already found the solution. But it is not possible to disable auto commit when you click ‘save’ option in table design.

 

---

If the answer is helpful,  please click "Accept Answer" and kindly upvote it.