Thank you all for your replies. I really appreciate the support.

This morning when he woke up, we had a talk about what happened. He claims he was feeling so sick because of the amount of greasy fried food he ate at the bar, and not so much the alcohol...which I don't really believe. He says he remembers everything that happened at the bar, conversations he had with coworkers, and that he waited a significant amount of time to drive home. He says he was “fine” driving home and when he got to our house and got out of the car, he started feeling nauseous.

None of this is great, but he does feel very, very bad about what happened and has apologized to me several times already. I don't think he'll be repeating this behavior in the future. If he does, though, I will have to think long and hard about my options.

@Jannaku - I think you're right about him getting swept up with the wrong group. He was with a group of coworkers he doesn't see very often (they work in a different office) as well as some colleagues from overseas who were in town for a conference. He's not a "let's do shots!" kind of guy at all, so I'm assuming he felt pressured into the shots when everyone else was doing them.