What are the challenges you face when working across database platforms? Take the survey

WITH requirement in NOLOCK hint

asentellasentell Posts: 42
edited December 31, 2009 10:54AM in SQL Prompt Previous Versions
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.



Sign In or Register to comment.