If that’s the episode I think it is, then there was no real connection with holy water - the vampire was trying to dig in ‘consecrated ground’ with his bare hands. Apparently the effect is the same.
Which brings up the question of if burying a dead person in consecrated ground will prevent them from rising as a vampire, or just really piss the vampire off.