While looking at Eli Wallace profile on the new Stargate site i noticed in one of the videos... The General Hammond
In the video where David Blue talks about Eli. In about half way through that video there is a small scene where Eli is standing inside one of the ships together with Dr. Rush and behind them there is a screen on the wall where you can read " USS General Hammond" So maybe that is where we will se Sam in the Pilot?
On the screen behind Eli and beside Rush you can almost see the USS Hammond text