I know this is an old post but maybe other people due to have an endoscopy will read this. Be very careful. Midazolam sedation does not always work. Not everyone who has Midazolam will get amnesia. I had endoscopy with no throat spray and midazolam sedation. It was absolutely horrific, they just gave me more midazolam and held me down, I remember it all. I have had no medical treatment since, and it is the cause of my PTSD and anxiety.