"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) (Using translation from Nasāʾī 5668)
«مَنْ شَرِبَ الْخَمْرَ فَلَمْ يَنْتَشِ لَمْ تُقْبَلْ لَهُ صَلَاةٌ مَا دَامَ فِي جَوْفِهِ أَوْ عُرُوقِهِ مِنْهَا شَيْءٌ وَإِنْ مَاتَ كَافِرًا وَإِنِ انْتَشَى لَمْ يَقْبَلِ اللهُ لَهُ صَلَاةٌ أَرْبَعِينَ لَيْلَةً وَإِنْ مَاتَ فِيهَا مَاتَ كَافِرًا» خَالَفَهُ يَزِيدُ بْنُ أَبِي زِيَادٍ