We were the same and after all the crying and rocking and exhaustion, we put a dummy in DDs mouth at 2am when she was a couple of weeks old and said if it works, lets do it and we'll wean her off it later.

DD is now 15 months and loves her dummy (but only for sleeping) and now we are thinking about the weaning part.