hi Ed,

Thanks for the reply..

still digging around trying to resolve it, possibility missing the point! (cant see the wood though the trees)

But using something like

USE Master

GO

SELECT *

FROM sys.dm_exec_requests

WHERE blocking_session_id <> 0;

GO

I get 2 LCK_M_IX that just wont go away it seems.

What do people like to do in this situation.. I know that one query is a agent job. So could kill it and re-run the code? Or is there more i can do?

As a side. could anyone explain what the WAIT_RESOURCE is and how to use it? (They both have the same : "OBJECT: 10:181575685:0 ")