Microsoft® SQL Server 2005 Unleashed

Chapter 26. Transaction Management and the Transaction Log

IN THIS CHAPTER

• What’s New in Transaction Management

• 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 in 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 in SQL Server 2005.

What’s New in Transaction ...