>>Did you try passing 3 commands to one command as a batch?
>
>Hi, Naomi
>
>I don't tried... because I rejected this sugestion - excuse me
>
>I have another SQL commands(insert, update, delete) to put between Begin and Commit/Rollback transaction
BTW, I use SP for such tasks when I need to run multple commands.
If it's not broken, fix it until it is.
My Blog