Vote for RESUMABLE TRANSACTIONS feature to include in SQL Server 2008
In oracle IF a session start with RESUMABLET RASACTION , If any DATA FILE got full for any reason the transactions running in that Session they will be waiting until you add more datafiles.
However,In current version of SQL if it ran out of space in data file it will die and rollback the whole transaction
Vote your interest on Connect site for this feature.