Re: How to disable automatic transaction in Management Studio?

microsoft.public.sqlserver.tools

31 Aug 2007 6:28 AM

Tibor Karaszi

In addition to the other posts, you can turn off "autocommit" in SSMS. Check under Tools, Options,
Query Execution, SQL Server, ANSI, SET IMPLICIT TRANSACTIONS.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quote

"Kin" <kin_***@yahoo.com> wrote in message
news:1188505601.732098.237590@x35g2000prf.googlegroups.com...
> Can I disable the automatic transaction in SQL Server Management
> Studio? i.e. I want to commit myself instead of having it
> automatically commited by Studio.
>
> Thanks
>