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 2:04 am

    #1224597

    jts_2003 (9/21/2010)

    Thanks for this. I wouldn't have realised that ROLLBACK would roll back a comitted transaction - doesn't this have ACID implications?

    It would be far worse if the inner transaction were not rolled back. The inner transaction is included in the outer transaction, so a ROLLBACK of the outer transaction should roll back everything that has been done by that transaction - including the nested transactions.

    See also the forum discussions that followed the previous two questions in this series.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/