Turn off updating intellisense
A while back we enabled showing error squiggles for the #include statements.
You can also disable automatic updates for the apps and drivers on your computer if you like.
When you are disabling the Microsoft Update Service, on tabs you'll see "recovery" is set to "one" in "one minute" and "at restart." change that to "9999," "day" and no restart.
Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. I've started using Azure Data Studio for day to day stuff. Having just spent two days with the same problem, I finally found the answer (in my case). If navigate to Root and are prompted to download the Microsoft Root file you should not have . It is not necessary to download the Microsoft Root file.
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community I recently got a new dev box, got my Visual Studio installed. Intellisense does not work in SQLCMD mode, and mine was on by default (Tools, Options, Query Execution, SQL Server, General, second last! Although the rule doesn't seem to relate to Intellisense issues at all, downloading the Microsoft Root file from the location specified in the error message and installing it into your trusted certificates, can alleviate some of the issues surrounding SSMS and performance.
In this example, I added another path (highlighted with the red underline) for the Intelli Sense engine to look for types.