Drain health enchant?

I have the "drain health" enchanted on one of my weapons but when I attack it only drains the health of opponents sometimes, other times it just acts as a normal attack. Is this how it should work or am I doing something wrong?