Use the sysprocesses table and check the blocked column. This column
will contain the process id of the process holding the lock. A simple
check for that process should tell you who has the lock.

--
David Rowland
MS SQL Server DBMonitor author
http://dbmonitor.tripod.com