hysteroctopy

I am having one next week?  Has anyone else had to have one?  Does it hurt very bad?  I really don't understand why he is doing it other than I am having side effect from the birth control.  Any insight?