It feels to me that Rodney's reputation for weapons inadequacy is undeserved, so I went through all the episodes I could remember him using a gun.

( Includes spoilers for Common Ground )

Details gathered from transcripts at Gateworld, where it's way too easy to see spoilers for much of Season 3.  However, I'm not particularly sad about this.