Code Analysis: Option to only enable for files, not for adhoc queries
Sometimes we do things in adhoc queries that would violate Code Analysis rules, or we just do not want to make the effort to confirm to all the rules. Of course you can toggle Code Analysis with Ctrl+Shift+A, but it would be easier (and make it impossible to forget to switch it back on for "real code") if SQLPrompt had a setting of which the effect would be that Code Analysis only was enabled for query windows that were using a physical file, and not for ahoc queries that are not saved to a file.
Thank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future.
Please feel free to request any additional features related to code analysis or Prompt in general by creating new suggestions.
The Prompt Team
Robert Paulsen commented
I agree with this in concept, except we don't work from saved files -- I was thinking "I only want this if the T-SQL is in a SPROC/VIEW".
Since it's mostly relevant for newly written code, maybe only statements that have an indicator in the indicator margin.