I'm working off an SQL 2008 instance that sits on our intranet. All is fine except that sometimes intellisense is there and working and sometimes it isn't. Its a pretty fast network so I don't imagine its a case that the RDBMS is reactively switching intellisense off because of latency issues etc.

Is there some other mechanism that can be used to ensure that intellisense always works?


It should revive when you refresh it's cache. In the menu is Edit - Intellisense - Refresh Local Cache (ctrl+shift+r). Or you can use another auto complete client like SQL Prompt or SQL Complete. First one has only paid version, while the second has also a free version.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.