This post says "the first episode of sherlock where john watson opens up his drawer and you see a gun".
So, it's talking about the Sherlock mini-series from 2010 which was set in modern times. I don't think that in modern times a military veteran is allowed to keep a gun in a drawer.