If I run this without a commit statement...
begin transaction
update dateranges set DateRangeTypeId = 1 where DateRangeId = 154
In another tab of Management Studio, I can select the range with Id 154 and it shows the old value for the type column.
Why doesn't the SELECT block on the updated row?