> I also want to know how is TransactionScope different from the old
> SQLTransaction.
Well it's not tied to SQL Server, to start with... it's a more general
transaction mechanism.
> Secondly, while using TransactionScope, how to
> determine whether the transaction was successful or not.
The docs aren't terribly clear, but it looks like you'll get a
TransactionInDoubtException if the commit fails.
Jon