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.
Although Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) implements locking automatically, it is possible to customize locking in applications by:
- Handling deadlocks.
- Setting the lock time-out duration.
- Setting the transaction isolation level.
- Using table-level locking hints with the SELECT, INSERT, UPDATE, and DELETE statements.
In This Section
| Topic | Description |
|---|---|
Describes deadlocks, which can occur when two connections have blocked each other. |
|
Describes lock time-outs. |
|
Describes transaction isolation levels. |
|
Describes the locking hints you can use in SQL Server Compact Edition. |
See Also
Concepts
Locking (SQL Server Compact Edition)
Understanding Locking
Displaying Locking Information