Customizing Locking with SQL Server

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.