1. Run "sp_who2 Active" to see all the active prossese including the one that is blocked. See what Process ID blocks it (number in the column BlkBy; if dot instead of number, it is not blocked or blocked "by itself").

2. Run "sp_lock <Process ID>" where Process ID is the one you found in the step 1 to see all the exclusive locks by the process (locks marked by X).

3. Look for object Id of the objects that are ocked exclusively. Find the object names. Think why those objects might be locked. Resolve the issues.

It is hard to cover everything or resolve complicated issues in the mode of this forum. Sorry if this was not enough but hope it helps.

Michael