Jeremy,

there is no any point in wrapping each statement in a begin tran/commit block because they are transactions anyway.

And I would guess that was a typo.

I really doubt real tables have got such funny names. 🙂

Regarding this I would say that devil is usually in details.

Posting real statements could be very helpful.

The real reason could be anything we don't see: misuse of parameters, remote calls, even typo in script.