No.
Use either explicit transactions ( begin trans/commit/rollback) or I think u could declare set trans something to set it to auto.

Vlad