I just had my first colonoscopy yesterday and it was a nightmare. They gave me a sedative(not sure what it was) and it had a slight effect on me. Unfortunately not enough of an effect because I was in pain from the word go. They got through the desce...