Question about Process Info

Hello, i just check the process Info in the sql server enterprise manager, I found two same user but different host (such as host1 and host2), and also i have update problem that write confilct error messager (i use access as front end and sql server as back end)
Does the two process cause problem? Actually i found the host2 computer actually is dead, why that host appear in the process Info, any body has idea? Thanks in advance.It's a ghost connection. The client died for whatever reason, but failed to notify the server that no results are needed. The server continues to process the request. Normally this situation is also associated with open transactions that are left behind uncommitted. The same user simply means that both users connected to the server with the same standard security context.|||rdjabarov, actually the one dead host is administrator's comptuer. How can i handle this, try to notify the server, actually i found this host also use lot message, and also it has login time, is that possible?|||What do you mean "lot message"? System table (sysprocesses) would display login info, that's why I am saying that the server "thinks" the connection is still alive. The only thing that is left to do is to kill the spid.|||sorry, i mean it use lot memory. So if i kill the spid today, it won't show up later, is that right?|||That's right, the same exact process will never show up again...but a different one originated by the same user from the same host may and probably will.