SQL Server 2000 is designed to serve multiuser environments. If multiple users try to access the same data, SQL Server must protect the data to avoid conflicting requests from different processes. SQL Server uses transactions and locks to prevent concurrency problems, such as avoiding simultaneous modifications to the same data from different users.
This chapter teaches you the following:
Basic concepts about transactions
How to use Transact-SQL statements to manage transactions
How to understand the common concurrency problems and avoid them when they arise
How to apply the right transaction isolation level
Lock types available in SQL Server
How to detect and avoid deadlocks