Disable "Track Changes" in SQL Server Management Studio
29 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.