Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nakul Vachhrajani Fun with Transactions - Part III RE: Fun with Transactions - Part III

  • September 21, 2010 at 12:51 am

    #1224560

    ziangij (9/20/2010)

    thanks for this question... i was wondering if you could you provide a question or a query that involves both ROLLBACK WORK & ROLLBACK TRAN 🙂

    When you simply issue a ROLLBACK, it is equivalent to issuing a ROLLBACK WORK.

    ROLLBACK TRAN is a special case, as it can only work with user-defined transactions.

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins