Hysteroscopy to remove polyp?

Has anyone has this done under conscious sedation at you doctors office?

And if so, was it painful?