Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.
FORCE_LEGACY_CARDINALITY_ESTIMATION option causes formatting and in some cases loss of intellisense

in SQL Prompt
Hello,
I recently upgraded from 9.x to 9.4.4.7199 version of sql prompt and I noticed that adding
OPTION ( USE HINT ( 'FORCE_LEGACY_CARDINALITY_ESTIMATION' )) causes sql prompt to not format it correctly.
In some large sql procs, it completely stops giving intellisense and starts adding random text when trying to auto complete etc.
I recently upgraded from 9.x to 9.4.4.7199 version of sql prompt and I noticed that adding
OPTION ( USE HINT ( 'FORCE_LEGACY_CARDINALITY_ESTIMATION' )) causes sql prompt to not format it correctly.
In some large sql procs, it completely stops giving intellisense and starts adding random text when trying to auto complete etc.
Answers
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/36714730-open-source-sql-prompt-s-formatting-module