Just noticed my machine was waking up at night in SL..... It looks like the issue if the firmtek drivers....
10/4/09 5:01:56 AM kernel Wake reason = RTC
10/4/09 5:01:56 AM kernel RTC: maintenance alarm 2009/10/4 12:01:55, sleep 2009/10/4 10:14:05
10/4/09 5:01:56 AM kernel System Wake
10/4/09 5:01:56 AM kernel /drv/ MacModule.cpp:261 powerStateWillChangeTo: flags=82 stateNumber=4
10/4/09 5:01:56 AM kernel /drv/ MacModule.cpp:262 powerStateWillChangeTo: found flag=kIOPMPowerOn (2)
10/4/09 5:01:56 AM kernel /drv/ MacModule.cpp:267 powerStateWillChangeTo: found flag=kIOPMRestartCapability (80)
10/4/09 5:01:56 AM kernel /drv/ MacModule.cpp:261 powerStateDidChangeTo: flags=82 stateNumber=4
10/4/09 5:01:56 AM kernel /drv/ MacModule.cpp:262 powerStateDidChangeTo: found flag=kIOPMPowerOn (2)
10/4/09 5:01:56 AM kernel /drv/ MacModule.cpp:267 powerStateDidChangeTo: found flag=kIOPMRestartCapability (80)
10/4/09 5:01:56 AM kernel FirmtekCtrllr:

owerStateDidChangeTo(): leaving system sleep
10/4/09 5:01:56 AM kernel Previous Sleep Cause: 5
10/4/09 5:01:56 AM kernel FirmtekCtrllr::setPowerState(): powerStateOrdinal= power_state_on. Waking up the system on the card with DevID = 31321095
10/4/09 5:01:56 AM ntpd[61] sendto(17.151.16.23) (fd=27): Can't assign requested address
10/4/09 5:01:57 AM configd[14] network configuration changed.
10/4/09 5:02:00 AM DashboardClient[458] (com.kamalaboulhosn.radarinmotion2) file:///Users/thomaslfessler/Library/Widgets/RadarInMotion.wdgt/weatherchannel.js: Error: NETWORK_ERR: XMLHttpRequest Exception 101 (line: 143)
10/4/09 5:02:00 AM com.apple.Dock.agent[205] 2009-10-04 05:02:00.031 DashboardClient[458:a03] (com.kamalaboulhosn.radarinmotion2) file:///Users/thomaslfessler/Library/Widgets/RadarInMotion.wdgt/weatherchannel.js: Error: NETWORK_ERR: XMLHttpRequest Exception 101 (line: 143)
10/4/09 5:02:01 AM racoon[198] [198] ERROR: failed select (Bad file descriptor)
10/4/09 5:02:03 AM kernel EIR is supported.
10/4/09 5:02:03 AM kernel SSP is supported.
10/4/09 5:02:03 AM kernel Ethernet [Intel82574L]: Link up on en1, 1-Gigabit, Full-duplex, Symmetric flow-control, Debug [796d,af48,0de1,0200,cde1,3c00]
10/4/09 5:02:03 AM kernel GbE en0: en0 Link down
10/4/09 5:02:03 AM configd[14] network configuration changed.
10/4/09 5:02:03 AM configd[14] setting hostname to "macpro.home"
10/4/09 5:02:06 AM kernel SerialATAPI device reconfiguration did not complete successfully. (failedCommandInfo = 0x1)
10/4/09 5:02:13 AM kernel /drv/ MacModule.cpp:261 powerStateWillChangeTo: flags=4 stateNumber=2
10/4/09 5:02:13 AM kernel /drv/ MacModule.cpp:266 powerStateWillChangeTo: found flag=kIOPMSleepCapability (4)
10/4/09 5:02:13 AM kernel FirmtekCtrllr:

owerStateWillChangeTo(): entering system sleep
10/4/09 5:02:13 AM kernel GbE en0: en0 Link down
10/4/09 5:02:13 AM kernel GbE en1: en1 Link down
10/4/09 5:02:13 AM kernel FirmtekCtrllr::setPowerState(): powerStateOrdinal= power_state_off. System is already sleeping
10/4/09 5:02:13 AM configd[14] network configuration changed.
10/4/09 5:02:13 AM configd[14] network configuration changed.
10/4/09 5:02:13 AM configd[14] setting hostname to "MacPro.local"
10/4/09 5:02:13 AM kernel /drv/ MacModule.cpp:261 powerStateDidChangeTo: flags=4 stateNumber=2
10/4/09 5:02:13 AM kernel /drv/ MacModule.cpp:266 powerStateDidChangeTo: found flag=kIOPMSleepCapability (4)
10/4/09 5:02:13 AM kernel System Sleep