Analyze Locks and Locking in SQL Server 2000

SELECT
 locktype  = CASE
   WHEN master..syslocks.type = 1 THEN ‘Exclusive table lock’
   WHEN master..syslocks.type = 2 THEN ‘Shared table lock’
   WHEN master..syslocks.type = 3 THEN ‘Exclusive intent lock’
   WHEN master..syslocks.type = 4 THEN ‘Shared intent lock’
   WHEN master..syslocks.type = 5 THEN ‘Exclusive page lock’
   WHEN master..syslocks.type = 6 THEN ‘Shared page lock’
   WHEN master..syslocks.type = 7 THEN ‘Update page lock’
   WHEN master..syslocks.type = 8 THEN ‘Exclusive row lock’
   WHEN master..syslocks.type = 9 THEN ‘Shared row lock’
   WHEN master..syslocks.type = 10 THEN ‘Update row lock’
   WHEN master..syslocks.type = 11 THEN ‘Shared next key lock’
   WHEN master..syslocks.type = 256 THEN ‘Lock is blocking another process’
   WHEN master..syslocks.type = 512 THEN ‘Demand lock’
  END,
 *
FROM master..syslocks
WHERE master..syslocks.dbid = db_id()
and id <> 0
ORDER BY master..syslocks.spid