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

SQL Prompt is triggering "Refresh Suggestions" constantly

I've been using SQL prompt for months without issue, then suddenly this morning nearly anytime I try to type a SQL statement the Refresh Suggestions popup (where it shows a progress bar as it indexes objects) shows up and interrupts any suggestions that were being offered.

How do I change this so it only refreshes suggestions when I invoke the keyboard shortcut? Before today it would only auto refresh suggestions when I connected to a new database. Now the auto refresh is so often it makes suggestions unusable.
KatMakes
0

Comments

2 comments

Sort by
  • Kurt_M
    Hi @KatMakes

    With regards to the constant refreshing, is it possible you have the following feature enabled? 

    This is under the SQL Prompt Options > Experimental Features:



    If yes, can you try disabling this to see if this fixes your issue?
    Kurt_M
    0
  • KatMakes
    Hi Kurt,

    That did indeed solve the issue. I had forgotten that feature was experimental.

    Once the feature is finished I'm sure it'll be great. But for some reason on this one Server/DB it just wants to constantly refresh itself.

    Thanks again!
    KatMakes
    KatMakes
    0

Add comment

Please sign in to leave a comment.