Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Enterprise Manager Not Responding
Message
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Miscellaneous
Thread ID:
00751426
Message ID:
00751957
Views:
14
Well, I feel like quite the idiot. It turns out that SQL Server was recovering the database, and that's why the EM was not responding properly and why I could not kill the spid. Good thing SQL Server didn't let me. Everything seems to be working OK now. Thanks for the input.

>Sorry for not responding earlier. All the lower process ID's are processes created by the sql server its-self. The user processes start at 50 I think. So thats why you cant kill spid 7.
>
>Other than that Im not exectly sure whats going on. Try looking in the current information/ locks area to see what locks are being applied. You might be able to see what two connections are blocking each other.
Chris McCandless
Red Sky Software
Previous
Reply
Map
View

Click here to load this message in the networking platform