Export (0) Print
Expand All

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.
© 2015 Microsoft