I am using SQL Server 2008.
What is the default lock behaviour with
How can I tell what the current level of lock is for a table?
migrated from stackoverflow.com Dec 14 '11 at 20:46
This question came from our site for professional and enthusiast programmers.
It really depends on how much you're updating. Locks will escalate as the size of the query increases. If many rows within the same page will be modified, SQL Server will escalate to a
The default behavior for update is to first take a row-level update (U) lock to read the data, followed by an exclusive (X) lock to write it.
You can see the current lock status of all objects in your DB by running "exec sp_lock".