WITH requirement in NOLOCK hint

asentell

I am very pleased with the latest release of SQL Prompt, so thanks for your hard work on this product. It makes my life a lot easier on a day-to-day basis.

The only issue I have is that when using the NOLOCK hint I have to include the WITH keyword (e.g., "WITH (NOLOCK)") in order for SQL Prompt to continue functioning. This isn't a big deal to me, but a majority of our stored procs do not include the WITH keyword so it would be nice if SQL Prompt did not require it.

Thanks,
Aaron

Anu D

Thanks for your post.

This issue was fixed in our latest version (4.0.3.10) can you kindly let me know which version are you using?

You can know the detailed version of SQL Prompt by navigating to SQL Prompt --> About SQL Prompt and version number is displayed on bottom right.

asentell

I'm using 4.0.2.57. Looks like I need to upgrade. Thanks!

Anu D

Kindly let me know if you need link to download the same.