By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,563 Members | 1,058 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,563 IT Pros & Developers. It's quick & easy.

Disabling the AUTOCOMMIT option in MSSQLServer

P: n/a
Hello,

Is there anyway.. we can disable AUTOCOMMIT option in MSSQL server
while executing the SQL queries via SQL ANALYZER

Jun 8 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
begin transaction

Jun 8 '06 #2

P: n/a
On 8 Jun 2006 08:01:15 -0700, Uncle Sam wrote:
Hello,

Is there anyway.. we can disable AUTOCOMMIT option in MSSQL server
while executing the SQL queries via SQL ANALYZER


Hi Sam,

In Query Analyzer (for SQL Server 2000): Tools / Options / Connection
Properties / Set implicit_transactions to ON. This affects only new
connections.
Also in Query Analyzer: Query / Current coonnection pproperties / Set
implicit_transactions ON to affect the current connection.

In SQL Server Management Studio (for SQL Server 2005): Tools / Options /
Query Execution / SQL Server / ANSI / SET IMPLICIT_TRANSACTIONS ON (for
new connections), and Query / Query Options / Execution / ANSI / SET
IMPLICIT_TRANSACTIONS ON (for the current connection).

--
Hugo Kornelis, SQL Server MVP
Jun 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.