Forum Discussion
SQL Server Snapshot Isolation
One of the data sets that the BI teams needs to report on is in an SQL database with SNAPSHOT ISOLATION enabled, but the READ COMMITTED SNAPSHOT option is not enabled. This type of configuration r...
I can't turn on READ_COMMITTED_SNAPSHOT because the application code wasn't designed for that. Years of development and testing was based on the application code taking locks. And it's not my application or code. So, I can't get the code tested and updated.
If there is way to enable it with an additional option, I could use some help. I'm not finding how to do it. That's why I posted here.
I'm wondering exactly the same thing. Did you ever get a solution for this?