Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Switzerland
    Posts
    4

    Question Unanswered: Imbricated transactions

    Is it possible to start a transaction inside another transaction ???

    Should I specify a particular isolation level ?

    Any ideas or tricks are welcome.

    ThanX

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Yes you can have nested transactions.

    When I have complex work to perform or cascading delets, I set IMPLICIT_TRANSACTIONS to on and then manage commits/rollbacks myself. Otherwise I stick to AUTOCOMMIT.

    I would encourage you to look up "transactions, described" in Books On Line.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •