Had mine today, no sedative, just the spray to numb the throat. All in all fairly unpleasant but it's all over and done with in less than ten minutes, and the effect of the spray wore off after another half hour or so. Seems I've got to be checked again in a couple of years and I'll just have the spray again next time.
I rather think the decision about having the sedative is a very personal one depending on how you feel about it, if you're at all apprehensive go for the sedative, if your relaxed about I just have the spray. From your posts Patsy it sounds as though you might well be a bit worried about it, go with a someone who can look after you and drive you home afterwards and have the sedative.
Best of luck with it, after it's all over you'll wonder what all the fuss was about.