// Create the TransactionScope
using (TransactionScope ts = new TransactionScope())
{
    using (SqlConnection cn2005 = new SqlConnection(someSql2005))
    {
        SqlCommand cmd = new SqlCommand(sqlUpdate, cn2005);
        cn2005.Open();
        cmd.ExecuteNonQuery();
    }

    using (SqlConnection cn2005 = new SqlConnection(anotherSql2005))
    {
        SqlCommand cmd = new SqlCommand(sqlDelete, cn2005);
        cn2005.Open();
        cmd.ExecuteNonQuery();
    }

    // Tell the transaction scope that the transaction is in
    // a consistent state and can be committed
    ts.Complete();

    // When the end of the scope is reached, the transaction is
    // completed, committed, and disposed.
}

// Create the TransactionOptions object
TransactionOptions tOpt = new TransactionOptions();

// Set the Isolation Level
tOpt.IsolationLevel = IsolationLevel.ReadCommitted;

// Set the timeout to be 2 minutes
// Uses the (hours, minutes, seconds) constructor
// Default is 60 seconds
tOpt.Timeout = new TimeSpan(0, 2, 0);

string cnString = ConfigurationManager.ConnectionStrings[
    "sql2005DBServer"].ConnectionString);

// Create the TransactionScope with the RequiresNew transaction 
// setting and the TransactionOptions object I just created
using (TransactionScope ts =
    new TransactionScope(TransactionScopeOption.RequiresNew, tOpt))
{
    using (SqlConnection cn2005 = new SqlConnection(cnString)
    {
        SqlCommand cmd = new SqlCommand(updateSql1, cn2005);
        cn2005.Open();
        cmd.ExecuteNonQuery();
    }

    ts.Complete();
}

using (TransactionScope ts = new TransactionScope())
{
    using (SqlConnection cn2000 = new SqlConnection(cnString2000))
    {
        cn2000.Open();

        SqlCommand cmd1 = new SqlCommand(updateSql1, cn2000);
        cmd1.ExecuteNonQuery();

        SqlCommand cmd2 = new SqlCommand(updateSql2, cn2000);
        cmd2.ExecuteNonQuery();
    }
    ts.Complete();
}

using (TransactionScope ts = new TransactionScope())
{
    using (SqlConnection cn2005 = new SqlConnection(cnString2005))
    {
        cn2005.Open();

        SqlCommand cmd1 = new SqlCommand(updateSql1, cn2005);
        cmd1.ExecuteNonQuery();

        SqlCommand cmd2 = new SqlCommand(updateSql2, cn2005);
        cmd2.ExecuteNonQuery();
    }
    ts.Complete();
}

private void Method1()
{
    using (TransactionScope ts = 
        new TransactionScope(TransactionScopeOption.Required))
    {
        using (SqlConnection cn2005 = new SqlConnection())
        {
            SqlCommand cmd = new SqlCommand(updateSql1, cn2005);
            cn2005.Open();
            cmd.ExecuteNonQuery();
        }
        Method2();
        ts.Complete();
    }
}

private void Method2()
{
    using (TransactionScope ts = 
        new TransactionScope(TransactionScopeOption.RequiresNew))
    {
        using (SqlConnection cn2005 = new SqlConnection())
        {
            SqlCommand cmd = new SqlCommand(updateSql2, cn2005);
            cn2005.Open();
            cmd.ExecuteNonQuery();
        }
        ts.Complete();
    }
}