Typically, resource locks don't last long. When the first user releases the lock, the second server SPID can lock the resource to continue processing a query. The Nitty Gritty of Locking SQL ...

based developer of SQL database management systems, recently announced availability of Version 2.2 of its ANTs Data Server. The product ... Thus, most databases use locking techniques to ensure that ...