LGibson69 (3/19/2009)
I expected to get no records because the transaction was still open but, when I ran it on SQL 2008 I got an error message saying "Msg 208, Level 16, State1, Line 3. Invalid object name 'test_tran'. Since this is the actual result I got I selected "None of the above" as the correct answer and was told I was wrong. I think I should get my "point" because my answer was technically correct. 🙂
I am guessing you are running in a case-sensitive environment. I am too and had the same error. I corrected the second query to use the same EXACT name as the first. I then had the proper result (based on SNAPSHOT ISOLATION being OFF).