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:

Management Studio with Track Changes 'enabled'

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):

Changing these settings results in a pleasant absence of the “track changes” bar:

Management Studio with Track Changes 'disabled'

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.