I am using sybase 220.127.116.11 on Windows NT.(Adaptive Server Enterprise/18.104.22.168/EBF 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?