Explicit commit

[Herve]

Hi All,

I don't know MS-SQLserver internal system at all. I 've just used Oracle
a couple years ago and so in some cases (e.g using TP-monitor MTS or Tuxedo)
you can switch off the implicit transaction by using
the option AUTOCOMMIT ON/OFF.

How can switch off the implicit transaction system on MS-SQLServer ?

In advance thanks,

Herve

[Gregory]

from Transact-SQL help: see 'SET' statement for IMPLICIT_TRANSACTIONS
Specifies implicit transactions.
Setting IMPLICIT_TRANSACTIONS opens an implicit transaction when the following statements are used:
FETCH ALTER TABLE
DELETE INSERT
CREATE OPEN
GRANT REVOKE
DROP TRUNCATE TABLE
SELECT UPDATE
When this option is turned on and if there are no outstanding transactions already, every ANSI SQL statement will automatically start a transaction. If there is an open transaction, no new transaction will be started. This transaction has to be explicitly committed by the user by using the command COMMIT TRANSACTION for the changes to take effect and locks released.


see if it helps

------------
Herve at 6/3/99 12:04:48 PM

Hi All,

I don't know MS-SQLserver internal system at all. I 've just used Oracle
a couple years ago and so in some cases (e.g using TP-monitor MTS or Tuxedo)
you can switch off the implicit transaction by using
the option AUTOCOMMIT ON/OFF.

How can switch off the implicit transaction system on MS-SQLServer ?

In advance thanks,

Herve