You are debugging an issue with the following code:

using (TransactionScope scope = new TransactionScope())
{
using (SqlConnection connection1 = new SqlConnection(connectString1))
{
SqlCommand command1 = new SqlCommand(updateCommandText, connection1);
command1.ExecuteNonQuery();
using (SqlConnection connection2 = new SqlConnection(connectString2))
{
SqlCommand command2 = new SqlCommand(insertCommandText, connection2);
command2.ExecuteNonQuery();
}
}
scope.Complete();
}

You find that under extremely heavy application load, the code intermittently throws a TransactionAbortedException when leaving the outermost using block. Closer investigation shows that ExecuteNonQuery calls do succeed. You must fix the problem.

What should you do?