Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chas036
Starting Member
2 Posts |
 Posted - 2004-09-24 : 10:48:50
|
| I'm on a SQL 2000 server and I have one process spid 54 that says (blocking) and another process spid 5 that says (blocked by 54) and no matter what I try, I can not kill either of them. I use the enterprise manager kill command and when I refresh the database the processes are still there. This has been going on for 4 hours. Can anyone help me? If I shut down the server, will this kill them? |
|
|
chas036
Starting Member
2 Posts |
Posted - 2004-09-24 : 11:28:08
|
| I discovered the problem is spid 5 is an autoshrink that is hungup and I can not kill a system process with the kill command. Does anyone know how to kill a system process? |
 |
|
|
|
|
|
Can't Kill Spids