ID Number: Q45643
1.00 1.10 1.11 4.20
OS/2
Summary:
If SQL Server escalates to table locking because so many individual
pages are locked that it is more efficient to lock the entire table,
it returns to page-level locking when the locks can be freed at the
end of the transaction (whether a COMMIT or ROLLBACK).