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.
>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05