Options

Disable automatic refresh

StephaneStephane Posts: 1 New member
in SQL Prompt
Hi,

Is there a way to disable automatic refresh every time I enter the SQL Source Control tab? Sometimes I spot errors before commiting, I open a new tab to fix the problem and then I've lost the id I need to fix my problem. I have to wait the whole validation operation before having access to my value once again. I would like to disable the automatic update and refresh only when I really need to.

Thanks in advance.
Tagged:
· Share on Twitter

Best Answer

  • Options
    RobynRobyn Posts: 177 Silver 5
    Answer ✓
    Hi Stephane, 

    Thanks for your post. 

    You can disable it to some extent:
    • Open %localappdata% in your File Explorer
    • Navigate to the folder Red Gate\SQL Source Control 7
    • Open the file RedGate_SQLSourceControl_CommonUI_UIOptions.xml
    • Add a new tag inside the root UIOptions
      <DisableAutoRefresh>True</DisableAutoRefresh>
    • Save the file
    • Restart SSMS
     However, 
    • The list of changes always refreshes automatically when switching to a different database in the Object Explorer
    • The list of changes always get refreshed after a commit or get latest
    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.