I have resolved my MacPro sleep issue by removing the Seagate 320GB stock drive. For whatever reason, if that drive is plugged in, it reboots my MacPro when waking from sleep. I had setup 2 WD 500GB drives in RAID 0 as my boot volume and this was configured with Windows XP Pro for other uses. Hope this helps someone else. Cheers!