'implicit transactions on' is normally the default.
How are you connecting, ODBC,ADO,syslib?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mark Derricutt
Sent: Monday, June 18, 2001 11:34 AM
To: Multiple recipients of list database
Subject: [DUG-DB]: Autocommit - sql-server 7/2000?
How does one tell sql server to go into auto-commit mode?
I currently have a call to 'set implicit_transactions on' when my
connection is created, and am calling 'commit' after every
update/insert/delete...
Mark
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
