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:

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.

Comments