With home-grown software this is likely a bug. In addition to what I mentioned before with nested transactions, you can simply have some poor timing going on in your...

Andrew Notarian (9/14/2011)

---

I am using the freeware SQL Check app from Idera, and in the processes window, I have some SPIDs with big fat red balls with blue centers. ...