The detective's revolver was changed somewhat recently in the first combat update PR. This change removed the non-lethal rounds that caused stamina damage and instead loaded the detective's revolver with lethal rounds. While previously you could load the revolver with lethal rounds this came with the risk of the gun blowing up in your face each time it was fired and took more work than just having them at round start.
Personally, I am not a fan of this change as, while the intention of this change was to reduce the amount of det-curity, I have witnessed a lot of detectives still just blasting people with their revolver. And as you can probably guess, for most antags it is a lot worse to be shot by a revolver with lethal rounds versus non-lethal rounds, because of things such as broken bones, internal bleeding, and death.
I would like to hear other people's points of view on this change though as there are probably some good things about this change that I haven't covered, such as more bad detectives getting job-banned for abusing their job?