Fast transactions with System.Transactions and Microsoft SQL Server 2000

The simplest way to use transactions today with Microsoft SQL Server 2000, using .Net Framework 2.0, is as follows:        static void Main(string[] args)        {            using (TransactionScope ts = new TransactionScope())            {                SqlConnection sqlConnection = new SqlConnection(“connectionString”);                sqlConnection.Open();                SqlCommand sqlCommand = new SqlCommand(“INSERT INTO …”, sqlConnection);                sqlCommand.ExecuteNonQuery();                sqlConnection.Close();                 ts.Complete();            }        } If you really…

19