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

SQL Prompt Intellisense not working

I am having trouble getting the very critical object-definition popup (Intellisense??) to display.

I just upgraded SSMS to v17.4 & Today upgrade SQL Prompt to 9.0.4.3408

is there a comprehensive list of Menus..Sub-menus...field/options that must be specified to get the feature to work?
Dave Devereux
0

Comments

12 comments

  • FabiolaB
    Hi DaveDev,

    I'm sorry to hear that you are encountering issues with the object-definition popup.

    Have you enabled suggestions for your database from the prompt menu (SQL Prompt/Enable Suggestions) ?

    Is there anything else on the screen ? Another popup that appears instead of the object-definition popup?

    Thanks,
    Fabiola
    FabiolaB
    0
  • DaveDev
    Thanks for your reply FabiolaB

    Yes, Enable Suggestions is checked - and nothing happens when I hover over an object (e.g. a table name), an alias or a SQL function.
    DaveDev
    0
  • FabiolaB
    Hi @DaveDev,

    Do other SQL Prompt features work? Can you format?
    Can you check that "Show tooltips for: Objects" is checked ?
    t3pgg8ivm5o7.png

    Thanks,
    Fabiola
    FabiolaB
    0
  • DaveDev
    Thank you @FabiolaB

    I did not have the Objects box checked - not sure how that happened but perhaps something due to the upgrade.

    I appreciate your help!!
    DaveDev
    0
  • DaveDev
    Oh & I did not notice any other problems with SQL Prompt.
    DaveDev
    0
  • FabiolaB
    Hi @DaveDev,

    Thank you for the feedback!
    Regards,
    Fabiola
    FabiolaB
    0
  • Sdev
    Hi FabiolaB,

    Im using MSSQL studio 17.9.1 and SQ Prompt 9.5.13.11024. I am experiencing the same issue even though  Objects is checked. This problem started after 2 previous upgrades for SQL Prompt. Please assist.

    Regards,
    Sdev
    Sdev
    0
  • lcestola
    I'm experimenting the same issue after upgrading to 9.5.15.11225 for complex queries in stored procedures (SP executes withour problems).
    I have the same configuration of Fabiola (aparts insertion keys)
    lcestola
    0
  • ssv
    Hi Redgate Team -

    I am on SSMS Version: 15.0.18424.0. The object suggestion stopped working. I read through the above suggestions and verified that those are checked. Are you able to provide any other suggestions?

    Interestingly, it is working in Prod but not in Dev. It was working in Dev too earlier but stopped working at some point.

    Thank you for your help! 

    ssv
    0
  • loadinga
    Hi,

    we have the same Problem. All suggestions from above checked.
    Prompt Version: 10.13.14.2694
    SSMS Version: 15.0.18384.0

    Thank you for your help!
    loadinga
    0
  • jeisenbeis
    Same problem, same situation as loadinga for versions.
    jeisenbeis
    0
  • loadinga
    loadinga
    0

Add comment

Please sign in to leave a comment.