SET IMPLICIT_TRANSACTIONS ON

Hi all

The SET IMPLICIT_TRANSACTIONS ON syntax turns on Begin Transaction by default,
yet when the ROLLBACK command is used everything in that session gets rolled
back. Is there a way to use the set implicit command to rollback only the
last transaction?

Thanks in advance
Driesen


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200508/1
.

Relevant Pages

  • Re: CLR Trigger Rollback
    ... I think you should use a ROLLBACK command instead of ... using (SqlCommand cmd = new SqlCommand("ROLLBACK", ... CREATE TRIGGER ti_ble ON ble FOR INSERT ... Transaction is not allowed to roll ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SET IMPLICIT_TRANSACTIONS ON
    ... > The SET IMPLICIT_TRANSACTIONS ON syntax turns on Begin Transaction by ... yet when the ROLLBACK command is used everything in that ... Note that in SQL Server nested transactions does not really exist. ...
    (comp.databases.ms-sqlserver)
  • Re: Cross Transactions between ADO & ADO.Net
    ... The issue of one result-set at a time has to do with transaction ... Can this restriction be gotten around using MARS? ... > MARS session pool limited to one connection?). ... >>> require two connections to the DB and if possible we would like a ...
    (microsoft.public.dotnet.framework.adonet)
  • IllegalArgumentException mit Hibernate und Tabellenrelation
    ... Als zentrale Tabelle gibts in der Oracle-Datenbank die Tabelle TASK. ... und zwar Task mit Agent. ... Session session = null; ... Transaction transaction = null; ...
    (de.comp.lang.java)
  • Re: bind() udp behavior 2.6.8.1
    ... "Transaction ID" in the DNS porttion of the packet. ... > ip:port and from no other server on the net. ... You new session is totally ...
    (Linux-Kernel)