Chapter 31. Transaction Management and the Transaction Log

by Ray Rankins

IN THIS CHAPTER

• What Is a Transaction?

• How SQL Server Manages Transactions

• Defining Transactions

• Transaction Logging and the Recovery Process

• Transactions and Batches

• Transactions and Stored Procedures

• Transactions and Triggers

• Transactions and Locking

• Coding Effective Transactions

• Long-Running Transactions

• Bound Connections

• Distributed Transactions

Transaction management is an important area within database programming. The transactions you construct and issue can have a huge impact on the performance of SQL Server and the consistency of your databases. This chapter takes a look at the methods for defining and managing transactions within SQL Server 2000.