• Really nice question!

    Missed that we did not have a batch terminator after "BEGIN TRAN" and that we were dealing with nested transactions here.

    Enjoyed the question thoroughly. Thank-you very much!

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

    Follow me on
    Twitter: @sqltwins