QA can automatically set implicit transactions for you. In the menu, go
to

Tools -> Options -> Connection Properties tab -> Set
implicit_transactions option

If you set this, you will need to explicitly commit or abort every batch
you submit through QA (or it will leave transactions open). Think of it
as an automatic BEGIN TRAN statement at the top of every batch.

If you don't have this option set, and you are not explicitly sending
BEGIN TRAN, your SQL Server connection will function in "autocommit
transaction" mode. This means that each individual statement in a batch
will be a separate transaction and will commit independently.

-----Original Message-----
From: Edwin Uy
[mailto:mssqldba-ezmlmshield-x35103745.[Email address protected]
Sent: Monday, May 31, 2004 7:38 AM
To: LazyDBA.com Discussion
Subject: SQL Query Analyzer

Hi all .

Can u set auto-commit on or off when using SQL Query Analyzer? Where and
how ???

Cheers,

EDWIN ONG UY

MS Sql Server LazyDBA home page