asked on

Can you set SQL Query Analyzer to automatically use NOLOCK on Queries?

Experts:

I'm a Crystal Reports expert. We've been instructed that when we use MS SQL Query Analyzer we must input the NOLOCK command with our queries. However that we do NOT need to worry about doing this with Crystal Report as they (DBA) tells me that Crystal Automatically does this.????(I'm checking with the Crystal Experts on this...)

I do not believe that Crystal Reports is using NOLOCK....as I can't see it in the SQL Query that is generated.

Anyway,...I'm just curious....is there a way to setup Query Analyzer to automatically consider my queries....AS .....NOLOCK.....??

Thanks

MikeV

Otana

As far as I know, this is not possible.

SOLUTION

rw3admin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Marcus Aurelius

ASKER

We have separate servers for each process: Development, Quality Assurance, Production.

Data on all of our servers are updated/refreshed every 15 mins.

Thanks for the added insight....it is much appreciated.

MikeV

ASKER CERTIFIED SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Marcus Aurelius

ASKER

Ahhhhh awesome.... yes..this is what I'm thinking about...

Thanks
MikeV

Marcus Aurelius

ASKER

Oh wait...but this would only be for users that would NEVER require...writing to database....correct?

Scott Pletcher

It would apply per connection. If the same connection were used for Crystal and, say, an app, the potential of "dirty reads" would apply to both. Usually I've found that Crystal uses its own connection, typically via ODBC.

At any rate, it doesn't prevent writing, since writing will *always* lock. You cannot turn off locking for inserts/updates/deletes; even if you specify it, SQL ignores it.