How was ancient sleeping medication made, what ingredients were used, and could any of them actually knock someone out cold?

The question topics include “Ancient Greece” and “Ancient Rome”. What part of my repertoire leads OP to believe I'm interested in those fields is beyond me. Also I don't think there are any Ayurveda experts on Kora, barring the odd Republican fraud, so I suggest OP go on pilgrimage to Haridwar or such places where humble Hindus gather to learn more on such things.

Also even if I'm answering this, it's not like I've read the accounts of Sushruta or Charaka or Dibyanath Das or the other saints. I've got a fairly good memory & I take note of the quirky stuff mentioned in the Classical plays & records I'm fond of, but I don't actually know anything about half the stuff I write.

Anyway…

Basically Early Classical and Classical surgeons plied the patients with Alcohol and Opium until they passed out. They'd also make compounds of Arista, Papaya, Katuchotti, etc but I'm skeptical whether they'd actually work without half-killing the guy. In theory, I've read that Arista can give a deep dreamless sleep, but it was also used to kill people, lol.

Don't ask me about their Latin names, I don't have a single clue