"I made sure my CPU was locked in place 'cause my computer shuts off if it isn't. "
I'm betting you meant to write about the CPU's heat sink and fan unit. If that falls off and you just stick it back on then voids in the heat sink compound may form. Fix? Add a little more compound and hope that's it.
Bob
While under minimal load, my computer spontaneously shut off. I rebooted, and several minutes later it happened again.
I booted down and vacuumed everything out. I made sure my CPU was locked in place 'cause my computer shuts off if it isn't.
When I tried to boot back up, it shut down in a few seconds. And again and again. Sometimes it will boot for up to thirty seconds but then shuts off.
Video, mouse, keyboard don't work. No beeps when it stays on for more than a few seconds.
I took out everything but one stick of RAM, the CPU, PS, and motherboard. Immediately shut off. When I put my GPU in, it stayed on for about fifteen seconds the shut off. Still no video.
Specs:
OCZ GameXStream 700w PSU
nVidia Geforce 8600GTS
Seagate 320GB SATA HD
nForce 650i Ultra chipset
Four 1GB 800Mz RAM
Core 2 Duo E6750 2.66GHz CPU
Nothing is overclocked.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic