The Missing Gun (2002)

A cop wakes up with a pounding hangover and a sickening realization—his service revolver is gone. Stricken with panic, he retraces his booze-soaked steps, desperate to recover the missing weapon before it's used in another crime. But the hunt turns personal when he discovers the gun is now in the hands of the same killer who shot his ex-lover to death. Now, he's racing against time to stop a murderer and reclaim his own lost honor.