SQL Server 2008 R2 intellisense not working

Question

SQL Server 2008 R2 Management Studio intellisense stopped working a month ago, although it is turned on. I read that this problem could be caused by the .NET Framework 4.0 SP1 and tried some of the suggestions, but nothing worked:

• I installed update rollup: SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64
• I re-registered TextMgrP.dll

Any other suggestions on what can be done?

SSMS Version: Microsoft SQL Server Management Studio 10.50.1617.0

Answer 1

• Make sure you are connected to SQL Server 2008 Edition. IntelliSense does not work with previous versions of SQL Server.

• IntelliSense must be enabled. There are two ways to check if IntelliSense is enabled or not. a) From the toolbar b) Go to Tools → Options → Text Editor → Transact-SQL → IntelliSense

• IntelliSense should be updated with the latest database changes. a) Press CTRL + SHIFT + R b) Go to Edit → IntelliSense → Refresh Local Cache

• Go to Tools → Options → Text Editor → Transact-SQL → General → IntelliSense Select AutoLinks and check the parameter information.

Answer 2

I have the same problem.
For me, the only thing that works is to manually select the database from the source code.

I just add

 use MYDATABASE; GO 

In my case, it looks like the source code cannot be connected to the default database.