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
Tuesday, March 20, 2012
Cant see hostname in sysprocesses
Labels:
application,
cant,
database,
hostname,
microsoft,
mysql,
oracle,
particular,
server,
sql,
sysprocesses,
troubleshoot
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment