USAF George Hammond
The USAF George Hammond was a Daedalus-class Battlecruiser in 2009. Samantha Carter was to be given command of it after General Landry returned from Washington. it was named after Lieutenant General George S. Hammond who died in late 2008 of a heart attack[1]. A few months later, the George Hammond transported several people to Icarus Base and unsuccessfully tried to defend the base from attackers[2]
Alternate TImeline
In an alternate timeline created when Sheppard ended up 48,000 years in the future. Carter took command of the Phoenix and went on a campaign against Michael. It took about a month of the Phoenix to be completed and combat worthy. During her campaign she destroyed an unknown number of Hive Ships. Sometime later, Michael set up an ambush that resulted in the destruction of the Phoenix as well as three of his Hive ships[3].