One of my coworkers gets regular shots to deal with chronic lumbar back pain. She's gotten them with both sedation and a local and been fine either way. And by fine, I mean that there is some discomfort later after sedation/the local wears off.