The pain lasted a few days. I had arthroscopic surgery done after and was in a cast for a month and a half and then I had physio recovery. Now, I have (hopefully) one last injection appointment.
If you can't stand medical procedures, make sure you get a doc that cares about the patients and doesn't have an assembly-line of procedures that day. The doc I had for the arthrography was a dick. The two surgeons I've had for the arthroscopy and injections have been great though!
Anesthetic? I can only do local anesthetic, because of my native heritage (just my father's line, not all natives, to clarify), I've got some sort of waking up problem (I don't). It's very rare that they put me under and it's some sort of quick acting expensive stuff they use when they do.
When you are scheduled for your arthrography, you can ask the admitting nurse questions and voice your concerns.
Hope I helped....