Sql thread blocking.

If you 've never dealt with a blocked Spid in SQL, it can be pretty intimidating...




But really it's pretty basic...




One thread (spid) has locked the table to modify it, and hasn't let it go.


Usually this is just a SQLcommand that's you've sent and you forgot to commit it.


Find that command and add the commit and you're all good. Usually...