• Good question!

    Explained situation is known as "Uncommitable transaction".

    MS SQL 2008 MCITP x 3
    MS SQL 2012 MCSE x 2