Ibn Buraydah narrates from his father, Sayyiduna Buraydah (may Allah be pleased with him), who said: We set out with the Messenger of Allah (peace and blessings be upon him) on a journey. We halted at a place, and we were about a thousand riders. He (peace and blessings be upon him) stood and prayed two rak'ahs, then he (peace and blessings be upon him) turned towards us with tears flowing from his eyes. Sayyiduna Umar (may Allah be pleased with him) stood up and went to him and said: "May my father and mother be sacrificed for you, O Messenger of Allah! What is the matter with you?" He (peace and blessings be upon him) said: "I asked my Lord for permission to pray for forgiveness for my mother, but I was not given permission, so I wept out of compassion for her from the Fire. I used to forbid you from visiting graves, so now visit them. I forbade you from storing the meat of sacrificial animals beyond three days, so now eat and keep it as long as you wish. And I used to forbid you from drinking in certain vessels; now drink in whatever vessel you wish, but do not drink anything intoxicating."
Hadith Referenceالسنن الكبرى للبيهقي / كتاب الجنائز / 7193