Tubes tied

Hi Ladies,
Next week I'm off to the doctor to ask about getting my tubes tied. I'm sure he'll agree as I have a medical condition.
I was just wondering what to expect after I've had the procedure done? Will I be in pain?