How to find out workstation name from net_address

Hi,

Is it possible to know workstation name from data in column
net_address from master..sysprocesses?

TIAHi

The hostname column in sysprocesses will contain the workstation name,
net_address is a MAC address which you would have to resolve through
something like arp.

John

"Eric Yang" <ericyang1991@.hotmail.com> wrote in message
news:7a8340df.0410291523.6df9385e@.posting.google.c om...
> Hi,
> Is it possible to know workstation name from data in column
> net_address from master..sysprocesses?
> TIA|||Eric Yang (ericyang1991@.hotmail.com) writes:
> Is it possible to know workstation name from data in column
> net_address from master..sysprocesses?

As John said, you can use the hostname column. However, this column is
not 100% reliable, as this is set through application code, and the
application can lie about it.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp