Dear All, There are more than 10 defunc process in a SQL Server 2000 (SP3). The last access date is on October 2005 but the status is runnable. It seems that these processes are defunc. I have tried to kill them but it does not succeed. Any way to prevent this? Any remedy to kill them without reboot?
My question was more to make sure that these are not system spids (spid < 50). It could be that the application has not closed their connections in the code. If this is a web application, it could be the connection pool, but connection pool connections will disconnect after 90 seconds of no use.