It will depend on the amount of sedation.
When I had an endoscopy, I actually asked them to give me enough so I wouldn't know anything about it - I hate gagging etc.
When I had a colonoscopy, they gave me just enough to make me feel relaxed, I could see the screen and I remember everything. So I would ask them not to give you too much. I had a uterine scan and biopsy taken in the the gynae's office with no anaesthetic at all - it was uncomfortable but bearable. Many women would love some sedation for this procedure - you are lucky. DG x