Process is not killed

[jluost1]

I run "kill 22" in SQL Query analyzer. (My current spid is 17).

But when I exec sp_lock and sp_who, I still see the process 22?

The reason I want to kill the process is that I would like to delete a corrupted database. Any idea?

Thanks.

 

[tlbroadbent]

Sometimes connections (SPIDs) cannot be killed. You have to stop SQL Server to clear the connection. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[jluost1]

That's it. I stopped then restarted the database and it works.

Thanks.