Post reply

Nested Trans in ADO

  • November 5, 2008 at 9:21 am

    #195607

    Hi all,

    I had a general question ... can you open nested transaction using ADO, and have 2008 manage them? or do you have to name each Transaction instance and manage their usage yourself?

    Thank you in advance,

    Maz

  • November 5, 2008 at 11:45 am

    #894455

    If you have a single connection in ADO and you start one transaction, when you begin a second transaction these will be "nested" transactions just as if you had opened two individual transactions in a stored procedure.

    Make sure you understand nested transactions if you use them - they act a bit strangely.

    I am not sure what having MARS active will do to this, but I think it will still work correctly. You could check the @@trancount from your connection to verify.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply