Customizing Locking and Row Versioning

Applications using the Microsoft SQL Server Database Engine can alter the default locking and row versioning.

Topic	Description
Customizing the Lock Time-Out	Handling time-outs and setting the lock time-out duration.
Customizing Transaction Isolation Level	Setting the transaction isolation level.
Locking Hints	Using table-level locking hints with the SELECT, INSERT, UPDATE, and DELETE statements.
Customizing Locking for an Index	Configuring the locking granularity for an index.