Current Activity - Host Question

When looking at the Current Activity screen in EM, why is that the Host comp
uter is displayed in some cases & not present in others?
For example, I have one generic report user, and in some cases I see the ser
ver name they are connecting to the sql server from and in other cases I don
't. Doesn't appear to be any rhyme or reason. Is some setting not properly
set?
Any direction on helping me understand this will be appreciated.It depends on the client. Some client libraries and versions grab the name
field automatically. Others wait for the application to populate it. ADO.N
et does populate the machine name automatically.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23CcqYHlJFHA.656@.TK2MSFTN
GP14.phx.gbl...
When looking at the Current Activity screen in EM, why is that the Host comp
uter is displayed in some cases & not present in others?
For example, I have one generic report user, and in some cases I see the ser
ver name they are connecting to the sql server from and in other cases I don
't. Doesn't appear to be any rhyme or reason. Is some setting not properly
set?
Any direction on helping me understand this will be appreciated.|||The setting is done from the client application (in the connection string).
Perhaps the app doesn't
set it properly?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23CcqYHlJFHA.656@.TK2MSFTN
GP14.phx.gbl...
When looking at the Current Activity screen in EM, why is that the Host comp
uter is displayed in
some cases & not present in others?
For example, I have one generic report user, and in some cases I see the ser
ver name they are
connecting to the sql server from and in other cases I don't. Doesn't appea
r to be any rhyme or
reason. Is some setting not properly set?
Any direction on helping me understand this will be appreciated.|||Geoff & Tibor,
Thank you for this information, now I know in which direction to begin.
Thanx!