http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx
Snapshot isolation is the only way to get around the problem.