The Glock 19 is the sidearm of the majority of the NYPD detectives in the film including Detective Terry Hoitz (Mark Wahlberg) and Detective Allen Gamble (Will Ferrell). Gamble is also seen being forced by Capt. Mauch (Michael Keaton) to carry a wooden version of a Glock as a "holster stuffer" replacement of his service gun after he is talked into, by Det. Fosse (Damon Wayans Jr.) and Det. Martin (Rob Riggle), doing a "desk pop". Gamble shoots his Glock into the ceiling of the police station as a brave stunt, prompting all the other officers in the room to draw their weapons on him, Gamble proudly saying "Hey, guys! I did my first desk pop!" Glock 19s are also seen in the hands of a couple of criminals. Throughout the film, the actors have fairly good trigger discipline, despite being, in Will Ferrell's case, very little weapon studded films.(IMFDB thanks The Golden Closet for providing the documentation on this gun; also see their sales page for Mark Wahlberg's weapon, here.)
In Detective Hoitz's flashback his Glock has switched into a "Non Gun" Glock. This was probably done for the safety of the actors during the scene.
Wooden Gun
One of the gags in The Other Guys begins when Det. Gamble is tricked into performing a "Desk Pop" with his Glock 19 inside of the police station and has his weapon temporarily confiscated and replaced with a wooden gun shaped like a Glock 19 throughout much of the film. (IMFDB thanks The Golden Closet for providing the documentation on this gun, as well as the image seen below.)
Det. Danson (Dwayne Johnson) is seen with what appears to be a nickel Colt Mk IV with pearl grips as his main sidearm. (IMFDB thanks The Golden Closet for providing the documentation on this gun; also see their sales page for the weapon, here.)
Charter Arms Undercover
Det. Terry Hoitz (Mark Wahlberg) keeps a Charter Arms Undercover with pearl grips as his back-up gun. He is most notably seen wielding it during the boardroom shootout.
SIG-Sauer P226R
Roger Wesley (Ray Stevenson) carries a SIG-Sauer P226R as his sidearm throughout the film. Some of Wesley's thugs also use P226Rs.
Wesley's P226R changes into a "Non Gun" SIG during the climax.
SIG-Sauer P232
Wesley's accomplice, simply billed as the "Brazilian Woman" (Tess Kartel) uses a two-tone SIG-Sauer P232 as her sidearm in the film. She most notably uses it in the boardroom shootout.
Astra 400
One of the robbers in the beginning, who are fleeing from Detectives Highsmith and Danson, uses an Astra 400.
Smith & Wesson Model 36
Captain Gene Mauch (Michael Keaton) carries a Smith & Wesson Model 36 as his sidearm through the film. Although Mauch confiscates Allen's Glock and comments that he'll give it back to him when he knows how to handle it, it seems that Mauch is the one with poor gun handling. This was probably done for comedic effect.
Beretta 92FS
A thug is seen holding a Beretta 92FS during the boardroom shootout.
Beretta 92FS Centurion
A Nigerian thug who jumps on Gamble's Prius after the boardroom shootout is armed with a Beretta 92FS Centurion. It is fitted with wooden grips.
Beretta M951
A Nigerian thug during the boardroom shootout is armed with a Beretta M951.
A Nigerian thug can be seen with a Ruger P89 during the boardroom shootout.
Taurus PT945
One of the Nigerian thugs can be seen with a Taurus PT945 during the boardroom shootout.
Tanfoglio TZ-75
One of the Nigerians in the boardroom uses a Tanfoglio TZ-75.
Walther P99
One of the bad guys in the boardroom shootout is seen using a Walther P99 against Det. Hoitz.
Heckler & Koch P7M13
One of the tjetjenian bad guys in the boardroom shootout is seen using a Heckler & Koch P7M13.
Solothurn ITM AT84S
One of the bad guys in the boardroom shootout is seen drawing and pointing what looks like a CZ-75 variant, maybe a Solothurn ITM AT84S, at Det. Hoitz.
A couple of thugs working for Wesley are seen with what look like a blued 1911 variant and a stainless or nickel plated 1911 variant.
Taurus PT92 AFS
Det. Gamble has an nickel plated Taurus PT92 AFS in his hand during a brief flashback from his pimping days in college. It has an accessory rail under the dustcover.
FN Minimi
One of the Rasta robbers fleeing from Highsmith and Danson in the beginning uses an FN Minimi (aka M249, the US adopted version of the light machine gun) to fire at Highsmith's Chevelle SS. He later dumps it as Highsmith comes crashing on the Rasta's Cadillac Escalade with his Chevy Chevelle SS.
SIG SG 556 Classic
A couple of Chechen assassins use SIG SG 556 Classic rifles from a helicopter to shoot at Gamble and Hoitz during the climax. The rifles appear to have M4 stocks installed instead of the original factory folding stock.
NYPD ESU officers are armed with M4A1 Carbines during the climax.
Desert Eagle
In some publicity material for the film (such as the poster above), Mark Wahlberg can be seen dual-wielding Desert Eagles with chrome finishes, spoofing various John Woo-style movie posters. On the movies web site, Wahlberg is seen firing these, hanging from cables, mocking the poster before crashing into Will Ferrell. Ferrell comments that he dropped his "$1,000 gun". Most Desert Eagles run in range from approximately $1,500-$2,200, making his comment somewhat correct.
SIG-Sauer P220 Sport
In some of the aforementioned publicity material, Will Ferrell can be seen wielding both a Desert Eagle and what appears to be a SIG-Sauer P220 Sport with an accessory rail integrated into the compensator.