Hi, I had to have 2 hsg's when I started my infertility work-up. It's not the most enjoyable thing, especially if you have cervical stenosis, which I have. You might want to talk to your doctor about prescribing you a mild anti-inflammatory. I was given motrin and darvocet. The procedure is uncomfortable. It will feel like very severe menstrual cramping. The radiologist had a hard time inserting the catheter because I had a huge fibroid/polyp that was blocking my right ovary, which is considered the stronger of my ovaries because of the way my cervix is tilted. I had surgery to remove them. When they initially found the fibroids/polyp's I had to have a pelvic ulstrasound and another hsg but this time instead of x-rays they used ultrasound. I was recently placed on clomid since I still haven't conceived. Hope this helps, let me know if you have any other questions...
P.S. If your partner wants to hold your hand trust me it helps to have them in there, but make sure that they have a good breakfast and don't get faint at the sight of blood becuase it can be a little bloody...My husband almost did a face stand and had to leave the room to get some air...I still tease him about it....