From The Stargate Omnipedia
Sergeant in the United States military. Smith was an S.G.C. officer whose life was once saved by Dr. Janet Fraiser.
Heroes, Part 2 - Samantha Carter mentions Sergeant Connie Smith, previously saved by Dr. Janet Fraiser, at the medical officer's memorial service.