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/techinf...2000/books.asp