Season 4, episode seven entitled Missing.
Teyla and Dr Keller (played by the very hot Rachel Luttrel and Jewel Staite) go to visit Teyla's people when they find out that someone or something has destroyed the village. They spot some potential enemies in the woods and quickly try to take stock of what weapons they have handy. Since it was a friendly visit they weren't carrying any guns, but Teyla pulls out her knife, which I think is a Cold Steel True Flight Thrower, but with all the sharpened prybar/paracord wrap type knives on the market these days I could be wrong.
Def