>>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
If it's not broken, fix it until it is.
My Blog