I have not had one but I know of someone who has. As far as I remember you need a referral, then you have to prepr 24 hours ahead so your colon is "clean". I think this invovles fasting and medicine which empties you out (this is probably the worst part of teh whole procedure). Then for the procedure they don't put you out but they do sedate you a little to keep you relaxed. Best of luck!
Was that in Canada? Just asking cos I know I was definitely out to it, not just sedated.

And yes, the clean out is the WORST part of the whole procedure.. .omg... you definitely need some soothing cream for your bum after a few times on the loo!!