That system will run BF2, but it will be at minimum specs and MAYBE slow.
The processor is fine, but you need 1GB of RAM to run BF2 smoothly AT MINIMUM. 2GB of ram will run it perfect.
Video card could also use an upgrade. How much can you spend, because it will cost you $300-roundbouts to make a BF2-perfect PC with 2GB RAM and a 6600GT.
Before BF2 came out, 1GB was considered perfect for gaming, but as soon as it came out, people found out that they had to bump it up to 2GB.
So overall, that PC will run BF2, but thats all its going to be doing, running BF2, and it won't be very good.