Love, he's an alcoholic. It sounds like you know this. As everyone has said upthread; you can't control it, you can't cure it, and you definitely did not cause it. And not only is it not your job to make him happy, it's not in your gift to do that: his drinking has nothing to do with you - he drinks because he is an alcoholic. You can (and no doubt will, because you love him, and that's OK) spend loads of time and energy giving him (depending on the circumstances of any given moment) threats, advice, ultimatums, support, pointing him towards help, etc etc, but unless he accepts he has a problem and more importantly wants to sort that problem out (there are plenty of alcoholics who know they are alcoholics and don't give a fuck), his behaviour is not going to change. There is literally nothing you can do to make it change.
So, with that in mind, the onus is on you love to protect your own boundaries: you can't control his behaviour, you can only control the affect it has on you. People far more experienced than me will have plenty of advice for you but I would suggest, for yourself, you have a look at Al-Anon's website: it's a support group for people whose life is, or has been, affected by someone else's drinking.
Good luck love, you must be reeling a bit reading this thread at the moment.