Hi-

After getting stuck over the weekend,  I am getting unstuck thanks to Mark. R, the group, and the Internet. I watched a slide share presentation done by a cool Russian on transactions. It helped me visualize what the heck is going on. I didn't really understand it all that well before the slide show.

I just did my first test  with 2 isql-fb open. As Mark R. mentioned, I may want a select to work differently, and I checked out the difference between snapshot and read committed to see how select behaved differently.
That is a really cool trick.

It is such a relief to not be as lost anymore. I will do some reading tonight and practice again tomorrow.

THANKS! - 3rdshiftcoder