Hi there,
We have an ERP system which is not one of the best out there and as a result we have quite a lot of ... challenges. We are also using Crystal Reports to get data from the MS SQL database used by the ERP. Recently, we were advised to use WITH NOLOCK on all out reports when querying the database. They (ERP tech support) say that by not locking the tables the number of problems that we have with their system will be reduced. What do you people think? Would it be a smart idea to modify all our existing reports (cca. 100) and add WITH NOLOCK with the SELECT statements? Is there any negative effect on doing this?
Thanks,
poli
We have an ERP system which is not one of the best out there and as a result we have quite a lot of ... challenges. We are also using Crystal Reports to get data from the MS SQL database used by the ERP. Recently, we were advised to use WITH NOLOCK on all out reports when querying the database. They (ERP tech support) say that by not locking the tables the number of problems that we have with their system will be reduced. What do you people think? Would it be a smart idea to modify all our existing reports (cca. 100) and add WITH NOLOCK with the SELECT statements? Is there any negative effect on doing this?
Thanks,
poli