carbreezy,
Current procedure for a Lumbar Puncture(LP) is quite easy, not like it was years ago when I had it
Although I was scared to death I did not use any medication for the procedure. My LP was done the old fashion way...hunt and peck

. The Radiologist hit a nerve the first time and almost got kicked...not my fault and he even said so

The second try was a winner
I had the LP first directly followed by a Myelogram and I was in the hospital for 48 hours.
When the radiologist withdrew the spinal fluid he showed me what it looked like, it was cloudy. He told me that means there is something going on. At my follow-up neuro appointment my neuro said the spinal fluid had high protein and I had 5 o-bands. He gave me the diagnosis of MS.
Good luck on your LP. You will be fine