Customizing Locking with SQL Server
SQL Server 2000
Although Microsoft® SQL Server™ 2000 implements locking automatically, it is possible to customize this in applications by:
- Handling deadlocks and setting the deadlock priority.
- Handling time-outs and setting the lock time-out duration.
- Setting the transaction isolation level.
- Using table-level locking hints with the SELECT, INSERT, UPDATE, and DELETE statements.
- Configuring the locking granularity for an index.