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");
