My girlfriend used to suffer from frequent migraines. The drug you're referring to, I think, is Imitrex (PDF document). She received a prescription of a nasal spray of the stuff - the only thing that was effective, and then only if she caught it early enough. If not, she had to be brought to the hospital for treatment via IV or injection.