Home Forums SQL Server 2005 Administering Lock escalation concept RE: Lock escalation concept
Ken McKelvey
SSCoach
Points: 18769
More actions
August 23, 2012 at 4:01 am
#1529142
Locks are acquired by a SQL connection.
If one connection acquires an X lock on a table that connection can still do a SELECT; it is just other connections that will not be able to SELECT against the table until the X lock is released.