Tuesday, March 20, 2012

Cant see hostname in sysprocesses

Why is it that a particular application does not show its hostname in
sysprocesses ? Its hard for us to troubleshoot since we cant see the
hostname.
What part within the application should i look in that ensures the hostname
would be displayed ?
ThanksIt is part of the information passed by the host application to sql server in
the connection string. Some applications set it, others do not.
SqlConnection.ConnectionString Property (System.Data.SqlClient)
http://msdn2.microsoft.com/library/f28szy5b(en-us,vs.80).aspx
AMB
"Hassan" wrote:
> Why is it that a particular application does not show its hostname in
> sysprocesses ? Its hard for us to troubleshoot since we cant see the
> hostname.
> What part within the application should i look in that ensures the hostname
> would be displayed ?
> Thanks
>
>sql

No comments:

Post a Comment