How do I use System.Transactions with SQL?

http://asp.dotnetheaven.com/howto/doc/transactions/TransactionsWithSQL.aspx