Continuity mistake: During the surgery, when they attempt to remove the Goa'uld, they start a timer. The timer starts at 00:00:00, then it blacks out (obviously, you don't want to be bored by major neck-surgery), and then the timer is at 01:19:49. However, seconds later (after Carter and Daniel's conversation), look at the timer in the background, it reads 00:23:46.
Plot hole: Huge plot error: Apophis and Clorell (Skara) should not have survived the explosion in Season 2, Episode 1 (when they attack Earth with two ships). In "Family" they explain that Apophis and Clorell survived by escaping through the stargate aboard Clorell's ship moments after Daniel Jackson did the same. However, when Daniel Jackson escapes through it, Apophis and Clorell are not even on the right ship, and there is 1 second left on the C4 timer when Daniel escapes. They actually show Daniel Jackson escape, and then cut to Apophis and Clorell still aboard their ship. So apparently, Apophis was able to "ring" from his ship over to Clorell's ship, make it to the stargate room, dial an address, and escape through the stargate all within literally 1 second. Is this guy related to The Flash?
Continuity mistake: Daniel's interaction is inconsistent across the episode. Initially, Daniel emerges through the Stargate with no ripples in the event horizon or audible noise. Then he walks down the metal ramp making noise with each footfall. Later in the episode he returns through the Stargate with an audible noise and ripples in the event horizon. He remained "out of phase" for the entire segment of the episode.
Revealing mistake: As we know, the watery image of the event horizon is projected onto a blue backdrop. In "Origin" the third episode of season nine, Ger'ak comes through the Stargate and we can see the image of the event horizon, though faint, around and above the Stargate itself and is not confined to normal area for the event horizon. Blatantly visible if you look for it on the airing of the episode on the Sci-Fi network.
Continuity mistake: When O'Neill and Carter arrive at Washington, Carter says "Don't worry, Sir. These were my old stomping grounds." O'Neill replies with "I'm sorry to hear that." But later when the reporter approaches O'Neill in the bar the recording says "My condolences."
Plot hole: Before the last chevron locks & the wormhole engages, Carter asks "Where's the iris" to which Hammond responds "Someone used a remote, whoever it is has our codes". All well and good, except without the wormhole being active, they wouldn't be able to receive the code.