Chapter 31. Transaction Management and the Transaction Log

by Ray Rankins


  • 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.

Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: