The music in "Code of Honor" is special because it's the only TNG episode scored by Fred Steiner, the most prolific composer for TOS. He did "The Corbomite Maneuver," "Mudd's Women," "Charlie X," "Balance of Terror," "What Are Little Girls Made Of?," "City on the Edge of Forever," "Who Mourns for Adonais," "Mirror, Mirror," "By Any Other Name," "Elaan of Troyius," "Spock's Brain," and the music to the "Way to Eden" songs. He also did some orchestration work on ST:TMP, making him the only composer to have worked on TOS, the movies, and TNG. (Steiner also composed the
Perry Mason theme and the score to the
Rocky and Bullwinkle show, among
many other diverse contributions to television music.)
At the beginning, TNG took a more classic approach to the music. Dennis McCarthy's score to "Encounter at Farpoint" and particularly Ron Jones' score to "The Naked Now" have a very TOS-like quality to them, and then they brought back Steiner to do "Code of Honor." But as the series progressed, the decision was made (probably by Rick Berman) to take a more modern approach to the scoring, and Steiner didn't return, nor were any other TOS composers used on TNG.
"Code of Honor"'s score is certainly the best thing about the episode and one of the finest scores in TNG. It's not Steiner's best work for Trek, but it's definitely a Fred Steiner score, a worthwhile addition to his impressive canon of Trek work.