>If you're using automatic transaction than yes. If you're using manual transaction than I wouldn't know w/o seeing what is included in a transaction.

By automatic transaction, do you mean I let SQL Server to do its own begin and end transaction? Because, I do not do this at the application level. I simply send the command as is.