To implement RCSI there really isn't anything you need to do to your code. It's the more traditional snapshot isolation that requires code changes. As Perry already stated, this will be invisible to your users. The one thing you should check though is that the connection strings for your applications need to either accept the default isolation level or use RCSI. If they set a different level, that's what will be used for that connection. However, it's pretty rare to see any code that sets the isolation level independently (but not impossible).