According to the following document (http://www.devx.com/dbzone/Article/32957/1954)
, you can have breaking application changes if your app relies on the normal blocking behaviour of SQL Server and you enable RCSI. However, the example he gives is not actually causing an issue in my test. Can someone confirm
using the code below?
First session ----->