>Amilcar,
>So there's not "locking" mechanism inherent within SQL Server?
>Yau

Hi Yau,

Actually, there are locking mechanism in SQL Server. SQL Server 2000 provides locks on 6 levels.

1. RID - stands for ROW ID, this lock applies to single row in a table.
2. KEY -
3. PAGE
4. Extent
5. Table
6. DATABASE

You should be using Enterprise version in order for you to use SQL Server Enterprise Manager to see and understand how it manages locks.

Regards,