Episode 118 of "Stargate-SG1"
s06e08 The Other Guys

While escorting physicists off-world, SG-1 is taken captive by Jaffa working for the Gou'ald Kon'su, an ally of Anubis. Two of the physicists, Felger and Coombs, who revere SG-1, must rescue them. Unfortunately, SG-1 actually let themselves be captured to contact Kon'su, who is a Tok'ra infiltrator. They tell the scientists to go into hiding. However, the Tok'ra's second sees through the deception, kills Kon'su, and takes SG-1 prisoner for real. Felger and Coombs must rescue the team for real, which they manage to do despite being...well, typical scientist/geek types. When they get back they get civilian awards and kisses from Sam...at which point Felger wakes up from his daydream.