How/why would I only use 2 parameters?

Jeff:

I set up my sp to mimick your example and it still is not rolling back the transaction.  Here is the output in QA:

Syntax error converting datetime from character...

Okay, so I set up my wrapper like Ray suggested.  Then I forced an error in spInsert_Customer by trying to insert a string of text into a DateTime field.  However,...

That makes sense, but from my first post, I specified that I need the called sps to also be their own transactions.

I've been grappling w/this for several days now.  I think your suggestion is the solution.  Thanks!!