Vasectomy

Anyone have a husband who went through a vasectomy but it wasn't successful?

Or if it was, how long did it take before he became sterile?