About this question
I'm having problems with a database. I can run basic queries, albeit much slower than normal.
When I attempt to view the hierarchy trees for tables, views, or procedures in SSMS Object Explorer, I get lock request time out period exceeded.
My SSRS reports that run on objects in this database are no longer completed. Jobs associated with procedures stored on this database also do not run. I tried using sp_who2 to find and kill all connections on the database, however this has not solved the problem.
What is going on here? How can I resolve this?
