Depends on which version... The rules for magic changed with each supplement that dealt with magic back in the days.
I found the 5e-version to be really underwhelming. You basically had to cast a spell at such a level that you took lethal damage from the drain for it to ve effective.