(44) باب ذِكْرِ الآثَامِ الْمُتَوَلِّدَةِ عَنْ شُرْبِ الْخَمْرِ، مِنْ تَرْكِ الصَّلَوَاتِ وَمِنْ قَتْلِ النَّفْسِ الَّتِي حَرَّمَ اللَّهُ وَمِنْ وُقُوعٍ عَلَى الْمَحَارِمِ
It was narrated that Ibn 'Umar said:
"Whoever drinks Khamr and does not get intoxicated, his Salah will not be accepted so long as any trace of it remains in his belly or his veins, and if he dies he will die a Kafir. If he becomes intoxicated his Salah will not be accepted for 40 nights, and if he dies during them, he will die a Kafir." (Sahih Mawquf)
Reference: Sunan an-Nasa'i 5668
In-book reference: Book 51, Hadith 130
English translation: Vol. 6, Book 51, Hadith 5671