Doesn't he want to prescribe sleeping pills at all, or just no benzo's? If the latter, you might ask to try a low dose of an antipsychotic such as Quetiapine (Seroquel).. Olanzapine (Zyprexa) helped me sleep, but I've never heard of it prescribed as a sleeping aid (it was prescribed to me as an antispsychotic, as was Clozapine, which also helps me sleep)

The benefit of sleep-inducing antipsychotics is that you can use them every night, whereas benzo's lose their efficiacy if you take them too often.