Format SQL Command inserts (Nolock) hints
JesseMelnick
Posts: 2
When I use the Format SQL command, it automatically inserts (NOLOCK) hints into my code. I can't figure out how to turn this feature off. Can anybody help?
Comments
We haven't heard of this behavior before and I'm struggling to recreate it here with the latest version. Could I check which version of Prompt you're using (under SQL Prompt->Help->About) and also do you have any other addins installed that might be affecting this?
Thanks,
Aaron.