I was wrong answer: "Outer transaction is still open....rolling back... ".

I learned that my wrong answer can be obtained with a SAVEPOINT:

CREATE TABLE MyTable (MyId INT IDENTITY (1,1),

...