Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sriram Transactions RE: Transactions
dmoldovan
SSCertifiable
Points: 6334
More actions
March 19, 2009 at 5:26 am
#962586
If you query sys.dm_tran_locks you'll see an IX lock taken on the test_tran table.
If you run in the second window SELECT col1 FROM test_tran WHERE col1 = 1 (or 2) the query will work.