LGA775 is a quite old socket, only Celeron, Xeon, Pentium and Core 2 lines of processors fit on your "mobo", and by fitting i mean just fitting, some motherboards don't support certain processors, my guess that the best upgrade you can atm do is to Core 2 Quad.
 
Pretty outdated socket, dunno if it's worth the money to get a new cpu for it at this point.
 
What Oaky And Evan said. Also that board only supports slower DDR2 Ram (4G max)which is outdated and also more expensive to find than current DDR3. No point in putting money into a newer CPU for that outdated board, imo.

There are very affordable motherboards out there for newer socket chips.
 
Pretty outdated socket, dunno if it's worth the money to get a new cpu for it at this point.
What Oaky And Evan said. Also that board only supports slower DDR2 Ram (4G max)which is outdated and also more expensive to find than current DDR3. No point in putting money into a newer CPU for that outdated board, imo.

There are very affordable motherboards out there for newer socket chips.
Well if I am to have to get a new board since finding a Intel Core 2 Quad might be difficult if I don't have the money sooner or later then what kind of board should I start up from?
 
Asus/Gigabyte make good boards, should be able to pick one based on price/reviews from newegg. If you want a less expensive board, ASRock or similar.

It all really depends on how much you're looking to spend, you can get a dual core with a decent clock rate for around 130ish, or you can spend more and get something more high-end.
 
Might as well just build a completely new computer if you have the money for good processor spend between $300-400 mobo $150-200 ram $100-150 psu $50 and just reuse your old video card and maybe another $50 on a new case you will spend an easy $600-800 oh and if you don't own a windows disk and your windows key is registered to the mobo that's another couple hundred to buy if I were you i would just invest in everything high end and you won't have to upgrade for a long time it will be well worth it.
 
There's no good reason to spend 300 or 400 dollars on a motherboard, you can easily get 16gB ram for a little over 100$.

All he really wants is a new CPU though, so all he really needs is a new mobo and cpu. But that's only if he wants something a bit more modern.
 
So you consider RAM capacity to be determining factor while shopping for motherboard, did I get it right?
It's pretty important, imo. For most people 12gigs will suffice, but 16gigs is helpful if you do a lot of media production.

Might as well just build a completely new computer if you have the money for good processor spend between $300-400 mobo $150-200 ram $100-150 psu $50 and just reuse your old video card and maybe another $50 on a new case you will spend an easy $600-800 oh and if you don't own a windows disk and your windows key is registered to the mobo that's another couple hundred to buy if I were you i would just invest in everything high end and you won't have to upgrade for a long time it will be well worth it.
Paying for windows. Did I just read that right?

At this point I'd recommend just building a new computer with quality parts. Makes more sense to me.
 
It's pretty important, imo. For most people 12gigs will suffice, but 16gigs is helpful if you do a lot of media production.
Nowadays RAM is cheap as dirt and all new MBs have slots for 12GB minimum. SATA3 (SSID support), socket, USB 3.0 presence, buss speed, number of PCIe 2.0/3/0 slots - that's what's important
 
Nowadays RAM is cheap as dirt and all new MBs have slots for 12GB minimum. SATA3 (SSID support), socket, USB 3.0 presence, buss speed, number of PCIe 2.0/3/0 slots - that's what's important
Oh, no doubt. I didn't mean to say choosing RAM was the most important factor, just one of them.