Hazrat Saeed bin Musayyib used to say that there is no sin except that Allah wants it to be forgiven, except for the prescribed punishment (hadd).
Imam Malik, may Allah have mercy on him, said: In our view, the ruling is that whoever drinks such an intoxicant in which there is intoxication, then the prescribed punishment (hadd) will be applied to him, whether he became intoxicated or not.
Malik said: The Sunnah with us is that whoever drinks an intoxicating beverage, whether he becomes intoxicated or not, the hadd punishment is obligatory upon him.
Hadith Referenceموطا امام مالك رواية يحييٰ / كتاب الأشربة / 1581