Autocomplete stopped working on SSMS 2016

11
votes

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:

enter image description here

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

So, how do I enable Autocomplete again?

5
sql-serverautocompleteintellisense
Try restarting your ssms, and if that doesn't work, restarting your computer. Sometimes that's all you can do. – Zohar Peled
Were you ever able to resolve this? – Flo
After trying all the above, I eventually the answer here: stackoverflow.com/a/50279972/979174 – JonV

5 Answers

9
votes

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

2
votes

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.

0
votes

IntelliSense stopped working for me, due to offline databases. After bringing them online again, IntelliSense worked again.

0
votes

My issue was solved by: Edit -> Intellisense -> Refresh Local Cache

-1
votes

My issue was solved by: Edit -> Intellisense -> Toggle Completion Mode