We have an application that is running a query that gets put in a suspended status. Specifically the query appears to hang and that particular process has a sysprocesses.status value of "suspended". It just sits there forever.
I have seen some posts on other forums that indicate this can be an issue with MSSQL 2005. We are on 2005 SP2.