by Ray Rankins
IN THIS CHAPTER
What Is a Transaction?
How SQL Server Manages Transactions
Transaction Logging and the Recovery Process
Transactions and Batches
Transactions and Stored Procedures
Transactions and Triggers
Transactions and Locking
Coding Effective 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.