Well, unfortunately, it's not a one-size-fits-all. If one spouse absolutely cannot be tempted by alcohol in the house than the spouses need to talk and work out a compromise.
My wife drinks every night and of course, I immediately take notice and am ever-so-slightly tempted to grab a beer myself, but I do not. I've been 17 days without a drink.
Each person and situation is different but I feel you have a right to request your spouse not drink if you feel so strongly about it.