Running for ten seasons, the show holds the record for longest-running American live-action science fiction TV series, second only to the British "Doctor Who" (1963) worldwide. Stargate SG-1 has run without a break (every year, without disruption) since start on July 27, 1997 to final episode on March 13, 2007; lasting almost 10 years.
I can't tell you anything about what happens after the cameras go off, mostly because I'm usually unconscious by then.
Come with me on a tour of all the stargates, from Stargate the movie to Stargate Universe. A lot of time and love went into the making of this tour. I hope you enjoy your visit.