>
>SQL Server have automatic lock escalation,
>out of developer control, this is one serious lack.
>
>However, because SQL Server do not have flat tables,
>but only index tables,
>then, i think, SQL Server have only index lock, page lock and table lock.
Fabio,
You're incorrect in your assumptions and there's no need to guess. I would recomend you to read the book
Inside SQL Server 2000 by Kalen Delaney which explains in details how SQL Server works.
--sb--