Login on SQL Server hangs
Posted on 2010-09-23
One of my users says that they cannot login to the database system.
Upon checking the event logs, we discovered something like this:
Process ID 71:12 owns resources that are blocking processes on Scheduler 5.
I found out that we had a batch processes that was running that was running for hours. When I try to login to the Enterprise manager to find out, I cannot login anymore. It hangs. I thought of DAC but it is not available for SQL Server 2000.
Any bright ideas would help.