Lightweight Transactions in SQL Server 2008http://blogs.msdn.com/b/socaldevgal/archive/2008/05/04/lightweight-transactions-in-sql-server-2008.aspxGood read which explains updates to SqlClient's System.Transactions in SQL Server 2008 which results in more light-weight transactions by reducing the 'auto-promotion' behavior ADO.NET team blog : Extending Lightweight Transactions in SqlClienten-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)