Huonglien Nguyen (3/6/2009)
I followed through the steps but eventhough after I executed "Commit tran a" the select * on dbo.test still showed me the old data: 1212121 and if I executed "Commit tran b" the select statement showed value 5. So I actually never saw the value 2 at all. Do you have any idea? Thanks.
I got the same results. The article seems very good and I have a much better understanding of SQL Server's row level versioning capabilities, but I got the same results here. Will continue reading for any insight into why this happens.
R