I dont see any hostname in sysprocesses

Why do I not see the hostnames in my sysprocesses ? I am trying to find the
names of hosts connected.
I see a net_address column. How can I track the hostname from the
net_address?
Also how can I ensure we get the hostnames to display..i..e. how do I get
the app devs to work this out.
ThanksHassan
If you use Citrix you do not see hostnames
"Hassan" <hassan@.test.com> wrote in message
news:eBoc9SxKIHA.5224@.TK2MSFTNGP02.phx.gbl...
> Why do I not see the hostnames in my sysprocesses ? I am trying to find
> the names of hosts connected.
> I see a net_address column. How can I track the hostname from the
> net_address?
> Also how can I ensure we get the hostnames to display..i..e. how do I get
> the app devs to work this out.
> Thanks
>|||Hassan;
That depends on the Workstation ID setting in the connection string of the
app. Many APIs will set it to the default local hostname if it's not
explicitly set. For instance, if you are using System.Data.SqlClient (.NET
SQL Server Provider) or System.Data.OleDb (.NET data provider for OLEDB),
both will set it to the local host name for you. But to ensure that hostname
is present, it's safe to always set the Workstation ID property explicitly in
the app's connection string.
Linchi
"Hassan" wrote:
> Why do I not see the hostnames in my sysprocesses ? I am trying to find the
> names of hosts connected.
> I see a net_address column. How can I track the hostname from the
> net_address?
> Also how can I ensure we get the hostnames to display..i..e. how do I get
> the app devs to work this out.
> Thanks
>
>|||"Hassan" <hassan@.test.com> wrote in message
news:eBoc9SxKIHA.5224@.TK2MSFTNGP02.phx.gbl...
> I see a net_address column. How can I track the hostname from the
> net_address?
>
In SQL Server 2005 you can have a CLR function to resolve the IP address to
host name. Most likely using System.Net.Dns.
HTH,
Plamen Ratchev
http://www.SQLStudio.com