Anyone has had a sigmoidoscopy

has anyone had a flexible sigmoidoscopy done, is it painful and how long does it take? Can the doctor put you to sleep? What are the after effects? happy to hear your comments.