SQLServer : Lock Status

You can see the lock status by sp_lock.

EXEC sp_lock
GO

Type on the result of sp_lock

Type	Description
DB	Database
FIL	File
IDX	Index
PG	Page
KEY	Key
TAB	Table
EXT	Extent
RID	Row ID