Disable "Track Changes" in SQL Server Management Studio
30 December 2011
For whatever reason, I get very little use out of the “track changes” feature in both Visual Studio and SQL Server Management Studio, which is designed to highlight lines that changed since the last save:
Visual Studio has an option to disable it entirely (Tools > Options > Text Editor > Track changes
), but Management Studio lacks this feature. As a
workaround, you can set the “Item background” color for these two items to
“Automatic” (available via Tools > Options > Environment > Fonts and Colors
):
- Track Changes after save
- Track Changes before save
Changing these settings results in a pleasant absence of the “track changes” bar:
It’s worth noting that Visual Studio’s behavior is slightly different. Setting the colors of these two options to “Automatic” maintains the original green and yellow colors instead of making them mimic the background color, as in Management Studio.