K.,
My husband had this procedure last December on a Friday and he returned to work on Monday. The actual procedure took around 45 minutes and my husband was awake during the whole thing. He had to take it easy for the first few days to keep down any swelling and experienced a little discomfort at the incision areas for a few weeks after but nothing terrible. For him, I think the worst part was the prep work before the actual procedure (shaving).
Then you use other protection for a minimum of three months before submitting a sample for testing. In about a week you'll find out if you have the all clear to discontinue the "other" protection. We received the all clear without any trouble. But, be aware if they find any swimmers the procedure will need to be repeated.
I personally didn't want to be the one to have my tubes tied as I've spoken to too many women who have experienced problems with their period after the procedure. After all, you were the one to give birth so let them do their part. My husband found it a very "freeing" solution.
Good luck!