I swear by Gonzo brand stain remover. It comes in a small white bottle... I find it in Home Depot's carpet department. Its somewhere around $3 or $4 per bottle.

I've gotten dried red paint off my beige carpet in two seconds flat! This stuff is truly amazing!