Autocomplete stopped working on SSMS 2016

Question

Autocomplete stopped working some while ago for me. Intellisense seems to be otherwise working.

I tried everything mentioned here:

• Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and Enable IntelliSense is selected
• Refreshed IntelliSense local cache: both Edit >> IntelliSense >> Refresh Local Cache or the CTRL+Shift+R keyboard shortcut to refresh
• Enabled statement completion: please go to Tools >> Options >> Text Editor >> Transact-SQL >> General, and checked on Auto list members and Parameter information boxes
• Rebooted SQL Server Management Studio several times
• Checked that shortcut "CTRL+Space" is enabled for "Edit.CompleteWord" in Text Editor in Tools >> Options >> Environment >> Keyboard

I have problem only with option:

• For each opening query window, please go to Query >> Intellisense Enabled

which is greyed out all the time:

I do not know, whether it is connected to my issue, but it might be.

So, how do I enable Autocomplete again?

Solution 1

it worked for me after pressing Alt+(Right Arrow)

Solution 2

I would recommend to forget about this issue and install 17.1 instead https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms. It is stable, free, looks beautiful and has more nice features than 2016.

Solution 3

Had the same problem: I did all the above mentioned. Solved it finally by disabling the SQLCMD Mode (which was activated)!

Comments

[JohnyL]

IntelliSense stopped working in 17.1 (build 13.0.4435.0). However, it worked previously.

[user2243747]

I am using 17.6 still IntelliSense not working on my machine