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

Refresh Suggestions Keyboard Shortcut Stops Working

Has anyone experienced this?  When I first open SSMS, for some period of time (usually 5-10 minutes) Ctrl+Shift+D refreshes the suggestions.  Then it stops working, I have to manually go to the SQL Prompt menu and click refresh.  If I close SSMS and re-open, it'll work for a little while again, then stop.
coneill
0

Comments

4 comments

Sort by
  • Kurt_M
    Hi @coneill

    It's possible that SSMS itself could be causing the issue. As a 32-bit application, SSMS can only access up to 4GB of memory on a 64-bit system. If SSMS is maxing out memory wise, then this might be one of the causes of your issue. To help resolve this, you could consider managing the size of your query windows, the number of open tabs and windows and closing any of them you aren't currently using. 

    Additionally, you can try using the Connections tab under SQL Prompt > Options to limit the number of servers that SQL Prompt loads suggestions for. This may help prevent SQL Prompt from slowing down by loading too many suggestions at once.

    Kurt_M
    0
  • coneill
    Thank you, I'll give these suggestions a shot.
    coneill
    0
  • Joelg
    Since a couple of weeks (or months back: I don't remember) the action to refresh using keyboard shortcut Ctrl+Shift+D stopped working.
    • The menu says this command is assigned. 
    • Clicking the menu item with the mouse still works.
    I solved it by assigning the command to Ctrl+Shift+R in Tools/Options instead and it started working again.



    Joel Greijer
    Joelg
    0
  • Joelg
    Found the root cause. It was Techsmith Snagit that stole the ctrl+shift+D shortcut for me. I had to disable it and all started working!
    Joelg
    0

Add comment

Please sign in to leave a comment.