United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Database Engine

Development

Querying and Changing Data

Accessing and Changing Database Data

Locking and Row Versioning

Customizing Locking and Row Versioning

Customizing the Lock Time-Out

Customizing Transaction Isolation Level

Locking Hints

Customizing Locking for an Index

Minimize

This topic has not yet been rated - Rate this topic

Customizing Locking and Row Versioning

SQL Server 2008 R2

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.