Autofill stopped working on SSMS 2016

Question

Autofill stopped working some time ago for me. Intellisense seems to work differently.

I tried everything that was mentioned here :

• Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense and Enable IntelliSense.
• Updated IntelliSense local cache: and Edit → IntelliSense → Update local cache or CTRL + Shift + R to update
• Completion of the completed statement: go to "Tools → Options → Text Editor → Transact-SQL → General and are checked with the" Auto-List "and" Parameter Information "
• Rebooting SQL Server Management Studio several times
• Checked that the shortcut "CTRL + Space" is enabled for "Edit.CompleteWord" in the text editor in the menu "Tools" → "Options" → "Environment"> "Keyboard"

I only have a problem with the option:

• For each window for opening a request, go to the Request section → Intellisense Enabled

which is grayed out all the time:

I do not know if this is due to my problem, but maybe.

So how do you turn on auto-complete again?

Answer 1

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

Answer 2

it worked for me after pressing Alt + (right arrow)

Answer 3

IntelliSense stopped working for me due to offline databases. After he reappeared on the net, IntelliSense worked again.