We have a company mandate to have every join include the directive "WITH (NOLOCK)". This is for a newer SQL Server where the isolation level can cause problems.
Unfortunately the Query Builder does not support the "WITH (NOLOCK)" option. Can we get this added? It could be put in the right click join menu or join properties dialog. Many databases have equivalent syntax.
This is a VERY BIG issue for this company. They bought Toad with a large number of Analysts needing to use a SQL Visual designer. They are upset when I told them the Query Builder does not support this.