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