In SS2000, I could do a simple example of locking by making a temp table in one query session and inserting a row in a transaction without committing. Opening a second query window would select from the temp table and show no results until the transaction in the other window was committed. In 2008, querying the temp table from another query window sits at the 'query executing....' indefinitely while the transaction is open in the other window.
Why?
I was trying to illustrate transactions for some students and this used to be a really simple way to do it. What do I need to do differently with 2008? I assume this is something to do with 2008's treatment of locks. Selecting in the second window with (nolock) shows the uncommitted row. But what I want is to return the result without the uncommitted row in the second window.
I'm using Express, does that make a difference?
Thanks for any help; sorry if this is a dumb question. I checked BOL in both the transactions and locks categories but didn't see anything that helped.