Hi,

Be sure you apply 'WITH NO LOCK' on every table of your FROM clause...

On the other hand, I think you should first find which INSERT/UPDATE statement holds locks for such a long time...

P.