How can we help you today? How can we help you today?

SQL Prompt expired - now SSMS Intellisense not working

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?
Frank Sposato
0

Comments

4 comments

Sort by
  • AlessandroAlpi
    hi Frangooch,
    try this guide. However, you can enable it pressing the intellisense button into SSMS 4UQt4.png
    AlessandroAlpi
    0
  • 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.
    Frangooch
    0
  • 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!
    Tianjiao_Li
    0
  • 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.
    Frangooch
    0

Add comment

Please sign in to leave a comment.