Skip to Content
0

Setting the Isolation level to Snapshot

Jan 25, 2017 at 02:05 PM

37

avatar image
Former Member

We are using BO XI 3.1 (last SP) with MS SQL Server 2008 R2.

We would like to use the snapshot isolation level for the queries run by our reports, instead of 'read uncommitted' which we use today.

We tried to change in the oledb.sbo file the parameter to 'snapshot', but we get an error when we try to refresh the reports telling us that the snapshot isolation level cannot be used.

Could you help us find the right way to use this isolation level?

Regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers