• If you can run sp_who2 and sp_lock, I would start there. When you run sp_who2 look at the BlkBy column to see what process is blocking the others. Check that process out in the sp_lock results and start your troubleshooting there. BOL has some good information on the results from sp_lock that will help you to analyze the issue.

    Hope this helps get you going in the right direction.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot