MS SQL Server - Cant see hostname in sysprocesses

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Cant see hostname in sysprocesses

Hassan

2005-07-18, 11:23 am

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

Alejandro Mesa

2005-07-18, 11:23 am

It 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
>
>
>

Sponsored Links