Excellent war story.

I think Rbarryyoung is right on the money. I believe that the lack of explicit transaction demarcation is the real problem.

Do you mind specifying explicit "begin tran"/"commit tran" ? It should work, right?