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.
Tagged:

Best Answer

  • Kurt_MKurt_M Posts: 176 Silver 1
    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?

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

Answers

  • KatMakesKatMakes Posts: 2 New member
    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
Sign In or Register to comment.