SQL Server 2000 Get Ip Address From Connected Client

Question

I am trying to find out from what machine is coming a connection.

Querying

select * from sysprocesses

I can see the hostname of the client what gives me host008.

However, when I try to ping the host008 from CMD this host is not found.

Using

exec xp_cmdshell 'ping host008'

or using PowerShell it gives me nothing, either.

What are my other options?

Answer 1

There was no host connected. The info's source was a DSN file to link tables in Access.