Advertisement
Published in:
2014 | OriginalPaper | Chapter
22. Application Locks
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
Abstract
There is another interesting SQL Server feature calledapplication locks. This feature allows an application to place the lock to the application resource, which is not related to the database objects and identified by the name only. The lock would follow the regular rules in terms of the lock compatibility, andit can be one of the following types: shared (S), update (U), exclusive (X), intent shared (IS), and intent exclusive (IX).