Don, you wrote in the article:
"It doesn't matter where the BEGIN TRAN and COMMIT statements reside between the two procedures. [...] So where you place your BEGIN...COMMIT is pretty much a matter of preference, not function."
This is true, as long as you put both the BEGIN TRAN and the COMMIT in the SAME procedure. For example, the following code would result an error:
CREATE PROCEDURE test AS BEGIN TRAN -- and do some work here GO
EXEC test COMMIT
And here is the result:
Server: Msg 266, Level 16, State 2, Procedure test, Line 4
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
Razvan