>>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

IMHO, you have to try them.

Otherwise use ADO Transactions, not SQL Server transactions as in your code.

Check this article (the principle should apply even if it's written for .NET):

http://www.code-magazine.com/Article.aspx?QuickID=0311051