Not necessarily unless you SET IMPLICIT_TRANSACTIONS ON

Regds,
Shrikant Patil

-----Original Message-----
From: Schlieper Paul
[mailto:mssqldba-ezmlmshield-x68322473.[Email address protected]
Sent: Monday, May 31, 2004 5:57 PM
To: LazyDBA.com Discussion
Subject: RE: SQL Query Analyzer

Nope,

Anything you do in QA is implicitly a transaction. You can wrap commands
in BEGIN TRAN -- ROLLBACK TRAN if you don't want things committed.

P


-----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
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius "How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page