I tried it on my local pc and it did not promote to DTC. It's easy enough to check by opening Component Services and navigate to "Component Services\My Computer\Distributed Transaction Coordinator\Transaction List" and watch for a transaction. Set a breakpoint in your code after you open the connection within the TransactionScope block to be sure you see any distributed transactions.

>Hi,
>
>>>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.
>
>Do you know which camp SQL Server Express falls in?
>Regards,
>Viv