SQL Prompt expired - now SSMS Intellisense not working

Frangooch

We purchased a subscription to Redgate SQL Source Control. It came with a trial of SQL Prompt which has expired. We are not planning to purchase SQL Prompt. However, since the expiration the intellisense in my SSMS no longer works even though it's enabled. How do we re-enable intellisense?

Tianjiao_Li

Hi @Frangooch ,

Can you please try the suggestions mentioned here:
https://dba.stackexchange.com/questions/6145/intellisense-not-working-but-it-is-enabled

Thanks!

Frangooch

The following solved the problem.

Verify Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense is checked (which I was already in my situation). However IntelliSense was still not working.

Go to Tools -> Options -> Text Editor -> Transact-SQL -> General. In my case the "Auto list members" and "Parameter information" appeared partially checked (e.g. solid color fill). After checking them the IntelliSense returned to normal.

AlessandroAlpi

hi @Frangooch,
try this guide. However, you can enable it pressing the intellisense button into SSMS

Frangooch

One of the first things we checked was making sure the SSMS settings for Intellisense were selected correctly, which they are. We verified both the menu Query --> Intellisense option as well as menu Tools --> Options --> Transact-SQL --> Intellisense.

Still does not auto-suggest. However if I key CTRL+J Intellisense will display a list of fields. The Intellisense was working fine before the SQL Prompt install. Re-install SSMS is our next step but was hoping there might be an easier answer.

Red Gate: for reference if you care to look into and fix the issue: SSMS version 13.0.16106.4 connecting to SQL Server 2016.