SQL 6.5 offers powerful tracking column in master..sysprocesses called net_address. I understand this is the 12 digit network interface card address of the PC associated with a particular process.

I`m looking for a way to associate the net_address with a IP address, netbios name, etc so I can determine what PC is associated with the process. I`ve tried TechNet CD and SQL Books Online and am drawing blanks.

At my site, SQL logins are often generic and depending upon the client application being run, hostnames may not be accurate, so being able to associate a NIC address to a PC name would be very useful for customer support, blocking debugging, etc.

Thanks in advance,
Bob McDermott