I am using sybase on Windows NT.(Adaptive Server Enterprise/ 11449 ESD#4/P/NT (IX86)/OS
4.0/rel12503/1939/32-bit/OPT/Sat Sep 20 22:28:57 2003)

Why does a process be still visible in sysprocesses table after there has been a network blip,status of this dead process is recv sleep.

e.g I login using SQL advantage and then I plugged off network cable and then restore the network and then still I can see my old process in sysprocesses table.
I have tested this on two servers and I have this strange behaviour on one of my servers where as on other server, I couldn't see old connection.

Could you please suggest me something on this issue?

Thx a lot