Well, from what I understand (again, any pros please step in) 300 dots (pixels) per inch is what's largely considered to be ideal printing resolution. At larger size prints that's sometimes not possible to achieve.
I personally haven't printed anything below 200 DPI; most of mine are around 240-260, and I try to get 300 on the pictures I really love.