|
Home > Archive > MS SQL Server > October 2006 > Where does "Application" come from in Activity Monitor?
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 |
Where does "Application" come from in Activity Monitor?
|
|
| Jeremy 2006-10-28, 7:14 pm |
| 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
| |
| Tracy McKibben 2006-10-28, 7:14 pm |
| Jeremy wrote:
> 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...
http://msdn2.microsoft.com/en-us/library/ms130822.aspx
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
| Linchi Shea 2006-10-28, 7:14 pm |
| 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
>
>
| |
| JeremyGrand 2006-10-28, 7:14 pm |
| > 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
| |
| Tracy McKibben 2006-10-28, 7:14 pm |
| JeremyGrand wrote:
>
> 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
>
>
No, sorry... To my knowledge, the connection string is the only way to
specify the application name...
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
| Scott Morris 2006-10-28, 7:14 pm |
| > 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?
| |
| JeremyGrand 2006-10-28, 7:14 pm |
| > 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
| |
| Jeremy 2006-10-28, 7:14 pm |
| > 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.
|
|
|
|
|