After many hours of assembling and fixing, my new upgrade computer now works. Not only does it work, it runs faster than you can say opteron.
Here's the final specs:
AMD Opteron 250 (SledgeHammer core)
AMD Opteron 250 (SledgeHammer core)
Thunder K8WE (S2895)
eVGA eGeforce 6800 Ultra (modified with pure copper water block)
eVGA eGeforce 6800 Ultra (modified with pure copper water block)
Crucial CT25672Y40B (DDR PC3200