15

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?

Community
  • 1
  • 1
frakon
  • 1,948
  • 2
  • 22
  • 26

9 Answers9

10

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

sushil.agarwal
  • 151
  • 1
  • 9
2

I would recommend to forget about this issue and install 17.1 instead https://learn.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.

Denis Reznik
  • 964
  • 5
  • 10
2

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

enter image description here

lennoxGER
  • 284
  • 1
  • 6
0

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

KVerwold
  • 261
  • 2
  • 9
0

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

stacky
  • 800
  • 6
  • 18
0

I tried all the suggested solutions but nothing worked then I realized it didn't effect the query windows that was currently open.

Simply opening a new query window solved it.

Rikard Askelöf
  • 2,762
  • 4
  • 20
  • 24
0

SSMS version 18.12.1

I found that Intellisense was failing on an existing large SQL query window with many lines of different queries contained within.

I took the suggestion from Rikard Askelöf of opening up a NEW query window, and Intellisense started working to auto complete the table names after I put a DOT after the schema name in a new query line.

I finally found the problem was caused by this: My large original query window had some "errors" in it from me pasting row data, and not commenting it out. I'm guessing Intellisense was getting so confused it just gave up.

Once I went through my query window and commented out all of the lines that had RED error's indicated by the scrollbar on the right, Intellisense works once again.

DBDAN
  • 1
  • 1
0

Invalid Linked Server Credentials

There is one additional case that I have seen. Took quite a bit of trouble to diagnose!

If the Server has a linked server and the credentials are no longer valid.

Autocompletion on objects freezes the cursor for a few seconds, then control comes back with no objects listed.

Peter Wright
  • 1
-1

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

kukabuka
  • 91
  • 1
  • 5