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

My pet hate

I use SQLPrompt a lot and I love it. One thing which drives me to distraction is the tooltips not showing. Arg!  I hover and I get a little grey box. I do not get a yellow tooltip with a link I could click to get the table or sproc definition. I used to be that doing Refresh Suggestions would sometimes make it work - but that is less likely to work now.  I have a query now that has tables that show the hint and others that do not. It is all perfectly valid SQL and one even has the Alt+Enter actions buld. Really frustrating!
Silverfrost
0

Comments

5 comments

Sort by
  • Jon_Kirkwood

    Hi @Silverfrost

     

    Thank you for reaching out on the Redgate forums, sorry to hear that your tooltips aren't showing up.

    That does sound particular, especially how you are stating it is working for some tables and not others.

     Are you able to confirm your version of SQL Prompt & SSMS you are running so we can verify compatibility. If you are not on the current version, we'd ask if you can patch and confirm this is still occurring.

    The patch to the current version (V10.14.4) is available per this link:

    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.4.4865.exe

     

    Also, it's possibly a bit silly, but can you confirm that you have Enable Suggestions on

    When I turn it off - I get the grey tooltip, but not extra tooltips to load the object definition.

     

    Jon_Kirkwood
    0
  • Silverfrost
    I am using version 10.14.4.4865. I am now using SSMS 19.2.56.2, I was using version 18 when I wrote the post. Enable Suggestions is definitely on. Next time it happens I will take a screenshot.
    Silverfrost
    0
  • Silverfrost
    It definitely still does it...  

    Here it will show the table but not the stored procedure. The sproc does exist and if I right-click and choose 'Script Object as ALTER' it will open it in a query window.






    Silverfrost
    0
  • Jon_Kirkwood
    Thank you for the screenshots, I've escalated this to our developers to be investigated further. 
    Will update this post with any findings from their investigation
    Jon_Kirkwood
    0
  • Buendia123

    I totally get your frustration! SQLPrompt is a fantastic tool, but those tooltip inconsistencies can be really annoying. If Refresh Suggestions isn’t working as well as before, you might want to try clearing the cache or restarting SQLPrompt to see if that helps. Some users have also reported better results after updating to the latest version.

    Speaking of setting things up properly, I recently came across some useful insights on Setting up a Betta fish tank. Just like getting SQLPrompt to function smoothly, ensuring the right conditions from the start can make all the difference.

    Hope you find a fix soon!

    Buendia123
    0

Add comment

Please sign in to leave a comment.