Saturday, 25 April 2020

IntelliSense is not working even though it is enabled.


I am using SSMS 2016,  My IntelliSense was working fine till few days back and suddenly one day it stopped working.

 I ignored it as I thought it will get fixed automatically.



But it was not fixed automatically, I have tried following options to get it fixed.



First tried with cache refresh.

     1.  Hit CTRL + Shift + R


     2.  Edit - > IntelliSence - > Refresh Local Cache

     and tried below options as well.
        
     1.  Go to Tools -> Options ->Text Editor -> General ->  Selected both the options  Auto list             members and Parameters information





      2. Go to Tools -> Options ->Text Editor -> IntelliSence -> Select option Enable IntelliSense. (Make sure it is enabled)


     3. Please make sure SQL CMD mode should be disabled for IntelliSense.
Tools -> Options -> Query Execution -> SQL Server - > General
Option ‘By default, Open new query in SQL CMD mode’ is disabled.

     Mostly the above trials will solve the problem, but unfortunately in my case, it didn’t worked so I have tried the below way.

     Go to Tools -> Options ->Text Editor -> IntelliSense -> Maximum script size setting Changed to unlimited.

















    If this is also not working for you, it seems like an issue with installation. I recommend to re-install the tools.


    Thank you for visiting the blog, hope you got the required information.




No comments:

Post a Comment