Customizing Locking with SQL Server

Although Microsoft® SQL Server™ implements locking automatically, it is possible to customize locking 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.