>If all operations are performed on a single connection though then the transactions uses plain ADO.NET transactions.
Should point out that the transaction will be a local non-distributed transaction only if connecting to SQL Server 2005. If you connect to any other database server including SQL Server 2000 it will promote to a full DTC transaction. This is because the other database resource managers do not support the automatic promotion of local transactions to distributed.
Michael McLain