Where does "Application" come from in Activity Monitor?

In sql 2k5 activity monitor, there is a column labelled Application.  It is
showing names for applications in some cases.  Where is it getting this
name?  I ask because many are blank for apps we've written internally, or in
some cases are old & need to be updated.

Jeremy

Jeremy  wrote:
> In sql 2k5 activity monitor, there is a column labelled Application.  It i
s
> showing names for applications in some cases.  Where is it getting this
> name?  I ask because many are blank for apps we've written internally, or 
in
> some cases are old & need to be updated.
>
> Jeremy
>
>

This comes from the database connection string that is defined within
the application...

http://msdn2.microsoft.com/en-us/library/ms130822.aspx




--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

If it is blank, then the application name property is not set in the
connection string.

Linchi

"Jeremy" <jeremy___ninprodata.com> wrote in message
news:OcyVmze%23GHA.3644@TK2MSFTNGP02.phx.gbl...
> In sql 2k5 activity monitor, there is a column labelled Application.  It
> is
> showing names for applications in some cases.  Where is it getting this
> name?  I ask because many are blank for apps we've written internally, or
> in
> some cases are old & need to be updated.
>
> Jeremy
>
>

> This comes from the database connection string that is defined within the
> application...

Tracy, I can find no trace of the app name that is reported.  I've searched
all of the apps source files, and even the .exe.  So, while it may be
possible to set the app name in the connection string, there must be some
other way to do it too.  I've looked at the various users, logins, & roles
in my sql server and the database in question, but so far haven't found any
candidates.  Any other thoughts on this?

Jeremy

JeremyGrand  wrote: 
>
> Tracy, I can find no trace of the app name that is reported.  I've searche
d
> all of the apps source files, and even the .exe.  So, while it may be
> possible to set the app name in the connection string, there must be some
> other way to do it too.  I've looked at the various users, logins, & roles
> in my sql server and the database in question, but so far haven't found an
y
> candidates.  Any other thoughts on this?
>
> Jeremy
>
>

No, sorry...  To my knowledge, the connection string is the only way to
specify the application name...


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

> Tracy, I can find no trace of the app name that is reported.  I've
> searched all of the apps source files, and even the .exe.  So, while it
> may be possible to set the app name in the connection string, there must
> be some other way to do it too.  I've looked at the various users, logins,
> & roles in my sql server and the database in question, but so far haven't
> found any candidates.  Any other thoughts on this?


Some part of VS2005 will supply a default value if not specified (".Net
SqlClient Data Provider"). Don't know under what conditions.  What name are
you seeing?

> No, sorry...  To my knowledge, the connection string is the only way to
> specify the application name...

What we have here is a dilemma, in that case.  Seems clear to me that the
app does not contain the string being displayed, either in a connection
string, or anywhere else.  Yet this is the only possible source for it.

Here's another factoid: when I run the app on my own pc, I see a blank app
name in activity monitor.  However, several users do have an app name shown
in activity monitor.  I have verified that they are running the same version
of the app that I am.

What am I overlooking here?

Jeremy

> Some part of VS2005 will supply a default value if not specified (".Net
> SqlClient Data Provider"). Don't know under what conditions.  What name
are
> you seeing?

Scott, the name is a name we used a number of years ago for this program
("AgentPro"). The app is a win32 app, written before .net was released.