Hi Mike ---

Let me know what you run into. That apparent auto-commit I ran into yesterday surprised the hell outta me because I assumed that none of the multiple UPDATES would be committed until SQLCOMMIT. So when I saw that all but the last one were committed WITHOUT an SQLCOMMIT, I was very, very surprised.

>That wouldn't make sense. The idea behind transactions is to be able to submit multiple DML commands to multiple tables.
>
>Maybe at lunch today I'll fire up the Profiler and run quick test.
>