Louis Ferretti

Louis Ferretti was a member of the original team that traveled to Abydos.

Biography
When the Stargate on Earth was reopened, he journeyed back to Abydos along with Jack O'Neill, Samantha Carter, Charles Kawalsky and a few other soldiers. When Apophis' forces attacked Abydos, Ferretti was badly injured and was carried to safety by Freeman before Freeman was killed. He managed to identify the gate coordinates Apophis entered before escaping through the gate.

Ferretti was made commanding officer of SG-2 following the death of Charles Kawalsky. When General Hammond ordered him to retrieve SG-1 for court-martial, he was unable to comply as SG-1 had gated aboard Apophis' ship and it had taken off, rendering the gate coordinates invalid.

Behind the Scenes
Ferretti has not appeared since the first season of Stargate SG-1, though he was briefly mentioned in the third-season episode "Shades of Gray", indicating he was still on staff at the SGC, thought it's unknown whether he was still commanding officer of SG-2 at the time.

In the feature film, his name was spelled with one "R" instead of two.