Zombie process 1

[lapdog]

I am running SQL Server 7 service pack 4. I recently ran a test select into and stopped it. Unfortunately, I now have a zombie process because the select into was not in a transaction. Currently, the process says open transaction and runnable but it has an exclusive lock on a index table preventing me from performing an update to a record in a batch process.

Is there any way of removing the lock or killing the process?

FYI: I have already tried Kill(spid) and reboot.

 

[MeanGreen]

You indicated that you already tried the kill process and that you have rebooted. In your SQL Error Log does it still show recovery in progress on the database where you ran this test? You might try to stop the SQL Server Service and make sure you disconnect your SQL Query Analyzer where you ran the initial INSERT INTO statement. Then restart the service and see if the process has stopped. Sometimes the KILL process appears not to work because it is doing a rollback of the transaction internally within SQL Server. Also, you might try DBCC CHECKTABLE on the table you were inserting into to see if that will free the connection. Good Luck!