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
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