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.