IntelliSense is not working in SQL Server Management Studio

Question

We use SQL Server Management Studio 2008 R2. IntelliSense works with SA account perfectly. But it is not working with Windows Authentication user. The user has access master db with db_owner role but it's not sysadmin.

How do I fix this issue?

Solution 1

You can try solution from these questions1 or questions2 and questions3.
Or please try these steps as below:

• Enable IntelliSense:
  • For all query windows, please go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and select Enable IntelliSense.
  • For each opening query window, please go to Query >> Intellisense Enabled.
• Enable statement completion: please go to Tools >> Options >> Text Editor >> Transact-SQL >> General, and check on Auto list members and Parameter information boxes.
• Refresh IntelliSense local cache: please go to >> Edit >> IntelliSense >>Refresh Local Cache or use the CTRL+Shift+R keyboard shortcut to refresh.
• Wait a minute or two for the Refresh to finish before trying again.

Solution 2

I had the same issue. Everything was enabled to ensure proper Intellisense functions, but didn't work. I realized I had SQLCMD mode enabled by default. Disabling it restored Intellisense functionality :)

Solution 3

This may seem too short of an answer, but probably it's the solution to your Problem:

CTRL+SHIFT+R

Also, I found this: Troubleshooting IntelliSense (SQL Server Management Studio)

Solution 4

Increasing the Maximum script size under Tools, Options, Text Editor, Transact-SQL, IntelliSense fixed Intellisense for me.

Solution 5

Missing from other solutions, but fixed it for me:

Edit > IntelliSense > Toggle Completion Mode

or CTRL+ALT+Space

View more solutions

Comments

[Ethem Kuloglu]

not working again. Everything is fine when loged in as SA. But other user(not sysadmin) cant use this feature.

[KarmaEDV]

Depending on the size and schema of the DB it can last several minutes until IntelliSense is populated

[JoeT]

That got it working. Strange. I set Maximum Script Size to 2 MB from 1 MB. Then I set back from 2MB back to original of 1MB and it's still working. That's odd as you'd expect it to stop working.

[Shaji]

I tried a million things before I stumbled upon this post. Really appreciate it. Intellisense worked on 2012 as soon as I unchecked sqlcmd.

[FAB]

Thanks for this suggestion. Although the option was already on, my intellisense did not work until the typical "turn it off and on again"...

[Dunc]

FYI, this is the keyboard shortcut for Edit > IntelliSense > Refresh Local Cache. Some of the other options in that menu may help, if this doesn't (I just tried them all).

[Kayathiri]

Thx a lot. I was struggling with this for a day.

[Moshe Yalovsky]

Changing the Maximum script size fixed it for me too. Everything else was set correctly!

[serge]

also, ensure you are connected! I didn't manage intellisense to work, because took a yesterday launched query window, and MSSMS was already disconnected. Once reconnected the intellisense worked! )

[esp]

Finally I have intellisense again - Enable statement completion was missing for me

[JonV]

This was the fix for me as well. I found that I needed to turn it on - and then OFF again (2X? I don't remember now).

[Andy Brown]

I had to turn SQLCMD mode off for all new queries (Tools > Options > Query Execution > SQL Server > General), then for some reason I needed to leave SSMS and go back in. Yeah - I have my Intellisense back!

[Josh B]

To my amazement, this fixed the issue for me too.