Eric Yang (er**********@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,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp