Can you set SQL Query Analyzer to automatically use NOLOCK on Queries?
Posted on 2006-11-10
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.....??