New training course: Customizing SQL Prompt. Watch now.

Disable automatic refresh


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.

Best Answer

  • RobynRobyn Posts: 124 Silver 4
    Accepted 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
    • Save the file
    • Restart SSMS
    • 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?
Sign In or Register to comment.