In the AcuLocks table, the column Lockpid contains the SQL Server Process ID or SPID which is locking
a record. How can the owner of the Lock be determined ?
If SQL Server 2012 is running, then open the SQL Server Management Studio.
On the left hand side in the 'Object Explorer' right click on 'Activity Monitor'.
This displays all the current processes running on the server.
For more information, execute this statement:
select * from sysprocesses where spid = nn
This will give the username, hostname and the host process ID of the process matching the argument.