1. RID - stands for ROW ID, this lock applies to single row in a table. 2. KEY - 3. PAGE 4. Extent 5. Table 6. DATABASEYou should be using Enterprise version in order for you to use SQL Server Enterprise Manager to see and understand how it manages locks.