Dear Sherlockians,
I think there is a mention of Dr Watson's army revolver in the Red
Headed League . Dr Watsom mentions in The Musgrave Ritual that Holmes
was in the habit of sitting in the drawing room and using a hair
trigger and a box of Boxer Catridges to make a VR on the walls of the
room. In the adventure of Charles Augustus Milverton , Holmes
carries with him House breaking implements . I personally feel that
Holmes seldom useda weapon being a martial arts expert himself(
single stick, Baristu and boxing) . There are many more refernces of
weapons in the canon but of hand I remember these. James , I hope I
have answered your query partially at least
sumal