Is there a way to force Report Builder to use "WITH (NOLOCK)" in the queries it generates?

Posted by Joe Pineda on Stack Overflow See other posts from Stack Overflow or by Joe Pineda
Published on 2010-12-22T19:51:53Z Indexed on 2010/12/22 19:54 UTC
Read the original article Hit count: 164

Hi. At work, users are very happy to generate their own reports using Reporting Services' Report Builder.

But, alas, the queries it generates are very inefficient, and they don't use "WITH (NOLOCK)" - slowing down things for everyone.

These are reports that really do need to be run using latest data - can't be offloaded to the reporting server. And since they query very specific, detailed data, hypercubes are of no use here.

So the question is:

Is there a way to configure Report Builder's Data Models so the queries it generates always use "WITH (NOLOCK)" when querying a table?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about reporting-services