It is narrated from Sayyiduna al-Sa'ib bin Yazid (may Allah be pleased with him) that the Messenger of Allah (peace and blessings be upon him) said: "Whoever drinks any intoxicant whatsoever, Allah does not accept his prayer for forty days."
Hadith Referenceالمعجم الكبير للطبراني / باب السين / 6642