I don't know if I just haven't found the option or if this is missing, but I always indent my code within a transaction block.
Code: Select all
BEGIN TRANSACTION
--Do stuff
COMMIT TRANSACTION
Code: Select all
BEGIN TRANSACTION
--Do stuff
COMMIT TRANSACTION
Am I just not setting the correct option?
Thanks,
Douglas