thanks for all of your responses.  The article on sqlservercentral....all about transactions was GREAT!  I came up with a standard for our SQL developers based on what I learned.

Chris

Even for multiple transactions, couldn't you just do

Begin Tran

   insert

  update

  delete

comit

if there's an error in any of the 3 commands, won't it rollback the entire transaction?

Thanks