Disable automatic refresh
Stephane
Posts: 1 Bronze 1
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.
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:
Best Answer
-
Robyn Posts: 195 Gold 1Hi 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
- 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