I was at exactly the same point as you when DD2 was 8 months old. DH was away, she was waking two hourly and i was going crazy. So i decided to try and night wean her. Like Traveller, i offered water, i cuddled, rocked, walked, jigged, everything, to resettle. The first night it took about 30-40 minutes to resettle her, then next night it was much quicker and since then she has slept 10-12hours a night. It took a lot of willpower to not feed her, i knew that it meant she'd go straight back to sleep, but it also meant she'd be waking up again and wanted the boob to go back to sleep. It was hard and i did feel a little bad, but i never left her on her own to cry it out, i comforted her in every other way i knew and in the end it paid off. The same thing worked for DD1, but it was much easier as DH was home and he settled her. She settled much quicker for him as she wasn't expecting milk from him iykwim. It took 2 nights for her as well and she too started sleeping all night.

Good luck. x