Dynamics NAV - SQL - Record is locked -exec sp_who2

A record In the Item Ledger entry table is locked

Run this

--------------------------------------------------------------------------------

CREATE TABLE #sp_who2 (SPID INT,Status VARCHAR(255),

      Login  VARCHAR(255),HostName  VARCHAR(255),

      BlkBy  VARCHAR(255),DBName  VARCHAR(255),

      Command VARCHAR(255),CPUTime INT,

      DiskIO INT,LastBatch VARCHAR(255),

      ProgramName VARCHAR(255),SPID2 INT,

      REQUESTID INT)

INSERT INTO #sp_who2 EXEC sp_who2

SELECT      *

FROM        #sp_who2

-- Add any filtering of the results here :

WHERE       DBName = 'ESL'

-- Add any sorting of the results here :

ORDER BY    DBName ASC, BlkBy desc, SPID

 

DROP TABLE #sp_who2

 

--KILL 78

-------------------------------------------------------------------------------------

Look for status of "Runnable" or any values in the "BlkBy" field