I have no idea what the song is or whether or not it was changed for reruns but the songs listed in that episode are
"I Like Dreamin'" by Kenny Nolan
"Undercover Angel" by Alan O'Day
"It's Ectasy When You Lie Down Next to Me" by Barry White
But when you mention cowbell all I can think of is "Don't Fear the Reaper" by Blue Oyster Cult
Anyway, hope this helped a little
