The following query is in the editor:
'select e.* from dbo.employee e (nolock)'
After adding the following, Toad looks like it will bring up a Code Completion pane, but does not
where e.last_name = '
At this point Toad has fired off a 'select e.* from dbo.employee e (nolock)' to the database. This has not been initiated by the user. The table is very large and causes issues on the server. The query does not show in the 'Background Processes' window, so the user is not aware that it's being run
WORKAROUND
Remove '(nolock)' from the query, or replace '(nolock)' with 'WITH (nolock)'
STATUS
Issue fixed in latest version 6.7. The latest release can be downloaded here.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy