--=_NextPart_000_0006_01C52627.EE921BE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
When looking at the Current Activity screen in EM, why is that the Host = computer is displayed in some cases & not present in others? For example, I have one generic report user, and in some cases I see the = server 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.
--=_NextPart_000_0006_01C52627.EE921BE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
When looking at the = Current Activity screen in EM, why is that the Host computer is displayed in = some cases & not present in others?
For example, I = have one generic report user, and in some cases I see the server 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.
--=_NextPart_000_0006_01C52627.EE921BE0--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@.TK2MSFTNGP14.phx.gbl...
When looking at the Current Activity screen in EM, why is that the Host computer is displayed in
some cases & not present in others?
For example, I have one generic report user, and in some cases I see the server 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.|||This is a multi-part message in MIME format.
--=_NextPart_000_00AE_01C5262A.B5A21F30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It depends on the client. Some client libraries and versions grab the =name field automatically. Others wait for the application to populate =it. ADO.Net 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@.TK2MSFTNGP14.phx.gbl...
When looking at the Current Activity screen in EM, why is that the =Host computer is displayed in some cases & not present in others? For example, I have one generic report user, and in some cases I see =the server 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.
--=_NextPart_000_00AE_01C5262A.B5A21F30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
It depends on the client. Some =client libraries and versions grab the name field automatically. Others =wait for the application to populate it. ADO.Net does populate the machine =name automatically.
-- Geoff N. HitenMicrosoft SQL Server MVPSenior =Database AdministratorCareerbuilder.com
I support the Professional Association for SQL Serverhttp://www.sqlpass.org">www.sqlpass.org
"JLS"
When looking at the =Current Activity screen in EM, why is that the Host computer is displayed in =some cases & not present in others?
For example, I =have one generic report user, and in some cases I see the server 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.
--=_NextPart_000_00AE_01C5262A.B5A21F30--|||Geoff & Tibor,
Thank you for this information, now I know in which direction to begin.
Thanx!
No comments:
Post a Comment