The very first thing I noticed was that after about 10 minutes of programming my Intellisense quit working and never came back. Strangely, I did not find the “correct” aka permanent solution to this problem.
So, after a ton of screwing around and guess-and-check, here’s how I solved it.
As a Developer or as a DBA you may face issues with Intelli Sence feature not to be working or not displaying latest scheme changes when you are writing TSQL code within the Query Window of SQL Server Management Studio (SSMS).
In this tip we will take a look at the steps you can follow to quickly enable and refresh Intelli Sence in SSMS to resolve this issue of Intelli Sense not displaying latest schema changes.
I noted JS was working and that requires web development tools to be installed, I also tried /Reset User Data but to no avail.
I installed Visual Studio 2015 Update 2 and it has been a nightmare.
Intelli Sence feature reads internal metadata and list all of the available objects and its properties thereby helping Database Developers, DBAs effectively and quickly write TSQL scripts.
However, there are certain occasions when Intelli Sence feature in SSMS doesn't work.
So, this post is about our beloved IDE instead of actual code. Note that you can now kiss your Visual Studio 2010 settings and preferences goodbye (your projects will be safe and sound). DELETE (or rename) all other folders that are not the “11.0” folder, assuming you used to have Visual Studio 2008 or whatever.
I recently upgraded my home PC from Visual Studio 2010 and 11 Beta to Visual Studio 2012. ” and then, after a swig of beer, proceeded to exercise my Google-Fu to solve this issue. Here you’ll see a folder titled “11.0” (the VS 2012 folder) and probably also “10.0” (the VS 2010 folder). Now restart Visual Studio 2012 and you should be good to go!