Ninja's_RGR'us (8/17/2010)

---

Here's a very crud way for solving the problem once in a while.

exec sp_who2

Look at the blocked by column. That will list the spid that is most likely blocking everyone else.

then run KILL <put spid here>.

Then rerun sp_who2 again to see if the lock is resolved. Sometimes you need to do this 2-3 times.