Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) supports multigranular locking that permits different types of resources to be locked by a transaction.
Automatic Locking
SQL Server Compact Edition automatically locks the required data to protect all the operations of a transaction, including:
- Data manipulation language (DML)
- Data definition language (DDL)
- Query statements at the required isolation level
SQL Server Compact Edition automatically locks rows of data, and any relevant index pages, to ensure maximum concurrency. As a transaction locks more resources, the granularity of the lock automatically increases to an entire table so that lock maintenance is reduced.
In This Section
| Topic | Description |
|---|---|
Describes the basics. |
|
Describes the process of converting many fine-grain locks into fewer coarse-grain locks. |
|
Describes the process of determining lock compatibility. |
See Also
Concepts
Locking (SQL Server Compact Edition)