SQL Prompt Intellisense not working

DaveDev

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?

FabiolaB

Hi @DaveDev,

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


Thanks,
Fabiola

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

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

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

Oh & I did not notice any other problems with SQL Prompt.

FabiolaB

Hi @DaveDev,

Thank you for the feedback!
Regards,
Fabiola

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

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)

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! 

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!

jeisenbeis

Same problem, same situation as loadinga for versions.

loadinga

I found the solution in this post: https://forum.red-gate.com/discussion/89979/update-has-caused-prompt-to-stop-working#latest