0

How to prevent record locking with SQL

We run Jet Reports with the Universal Connector to our SQL Server database. The problem is some of these Jet Report's can be quite large and time consuming and it does a record lock in SQL while it's running. Is there any way to add the "SET TRANSACTION ISOLATION LEVEL TO READ COMMITTED" to the Jet setup so that it doesn't record lock our data? Thanks for any feedback.

0 comments

Please sign in to leave a comment.