application name in profiler, could it be modifed

Hi,
We have 500+ dts running 24 X 7 ,started from dts run
In profiler every enty in application name column show as Dts
designer.
1.
Is possible to modify dts property or anything and add customer
informatiom ?
example
application name = dtsrun - Insert_Into_table_X
2.
is possible to modify application name for any connection ?
Thanks
AlexSure. For a SQL connection just bring up the properties and click on the
Advanced button and you'll see an Application Name property. You could for
example add an ActiveX script task to the start of your package that loops
through the SQL connections and sets the Application Name property of the
connection to the package name.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<t2581@.hotmail.com> wrote in message
news:1137770497.717723.119880@.g14g2000cwa.googlegroups.com...
> Hi,
>
> We have 500+ dts running 24 X 7 ,started from dts run
> In profiler every enty in application name column show as Dts
> designer.
>
> 1.
> Is possible to modify dts property or anything and add customer
> informatiom ?
> example
> application name = dtsrun - Insert_Into_table_X
> 2.
> is possible to modify application name for any connection ?
>
> Thanks
>
> Alex
>

application name in profiler, could it be modifed

Hi,
We have 500+ dts running 24 X 7 ,started from dts run
In profiler every enty in application name column show as Dts
designer.
1.
Is possible to modify dts property or anything and add customer
informatiom ?
example
application name = dtsrun - Insert_Into_table_X
2.
is possible to modify application name for any connection ?
Thanks
Alex
Sure. For a SQL connection just bring up the properties and click on the
Advanced button and you'll see an Application Name property. You could for
example add an ActiveX script task to the start of your package that loops
through the SQL connections and sets the Application Name property of the
connection to the package name.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<t2581@.hotmail.com> wrote in message
news:1137770497.717723.119880@.g14g2000cwa.googlegr oups.com...
> Hi,
>
> We have 500+ dts running 24 X 7 ,started from dts run
> In profiler every enty in application name column show as Dts
> designer.
>
> 1.
> Is possible to modify dts property or anything and add customer
> informatiom ?
> example
> application name = dtsrun - Insert_Into_table_X
> 2.
> is possible to modify application name for any connection ?
>
> Thanks
>
> Alex
>

application name in profiler, could it be modifed

Hi,
We have 500+ dts running 24 X 7 ,started from dts run
In profiler every enty in application name column show as Dts
designer.
1.
Is possible to modify dts property or anything and add customer
informatiom ?
example
application name = dtsrun - Insert_Into_table_X
2.
is possible to modify application name for any connection ?
Thanks
AlexSure. For a SQL connection just bring up the properties and click on the
Advanced button and you'll see an Application Name property. You could for
example add an ActiveX script task to the start of your package that loops
through the SQL connections and sets the Application Name property of the
connection to the package name.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<t2581@.hotmail.com> wrote in message
news:1137770497.717723.119880@.g14g2000cwa.googlegroups.com...
> Hi,
>
> We have 500+ dts running 24 X 7 ,started from dts run
> In profiler every enty in application name column show as Dts
> designer.
>
> 1.
> Is possible to modify dts property or anything and add customer
> informatiom ?
> example
> application name = dtsrun - Insert_Into_table_X
> 2.
> is possible to modify application name for any connection ?
>
> Thanks
>
> Alex
>

Application Name

Hi
Does anyone know how the ODBC driver gets the application name that is
displayed by the SQL Server profiler? Our application does not explicitly
pass it in with the connection string but we are seeing a name under the
ApplicationName column in SQL Server profiler.
Many thanks
Shakti
I'm just curious. Does the application name that is generated make sense? I
know that if I don't set one in ADO.Net, the app name is something like ".net
client." If I need the information to say something that I really need to
set the AppName
Russel Loski, MCSD.Net
"Johnny" wrote:

> Hi
> Does anyone know how the ODBC driver gets the application name that is
> displayed by the SQL Server profiler? Our application does not explicitly
> pass it in with the connection string but we are seeing a name under the
> ApplicationName column in SQL Server profiler.
> Many thanks
> Shakti
>
>
|||Hi,
there are several way, one would be to tweak the connection string with
the appName parameter.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Agree that your suggestion is the way to set the application name but if it
is not set by the application where does it get the name from? I can see
the program name in the sysprocesses table but if the application is not
setting it explicitly where does it come from?
Thanks
Shakti
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169569609.022799.219340@.l53g2000cwa.googlegr oups.com...
> Hi,
> there are several way, one would be to tweak the connection string with
> the appName parameter.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
|||Still from the application side. It's a parameter for the
connection string, property for the connection, different
ways depending on the application.Not all connections from
applications will supply them.
-Sue
On Tue, 23 Jan 2007 20:39:32 -0000, "johnny"
<prem14@.acm.org> wrote:

>Agree that your suggestion is the way to set the application name but if it
>is not set by the application where does it get the name from? I can see
>the program name in the sysprocesses table but if the application is not
>setting it explicitly where does it come from?
>Thanks
>Shakti
>"Jens" <Jens@.sqlserver2005.de> wrote in message
>news:1169569609.022799.219340@.l53g2000cwa.googleg roups.com...
>
|||We are going round in circles! Application is neither supplying the
application name parameter nor setting any connection property whatsoever.
So, where does ODBC driver / sql server / sysprocesses get the program name
from? It appears to have our company name!
Cheers
Shakti
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:m9hdr2h8qehp2c1q96jibubcmd44s900ht@.4ax.com...
> Still from the application side. It's a parameter for the
> connection string, property for the connection, different
> ways depending on the application.Not all connections from
> applications will supply them.
> -Sue
> On Tue, 23 Jan 2007 20:39:32 -0000, "johnny"
> <prem14@.acm.org> wrote:
>
|||Client would have been the better word to use rather than
application. It depends on what application.you are using.
And driver.
-Sue
On Wed, 24 Jan 2007 11:30:36 -0000, "Johnny"
<prem14@.acm.org> wrote:

>We are going round in circles! Application is neither supplying the
>application name parameter nor setting any connection property whatsoever.
>So, where does ODBC driver / sql server / sysprocesses get the program name
>from? It appears to have our company name!
>Cheers
>Shakti
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:m9hdr2h8qehp2c1q96jibubcmd44s900ht@.4ax.com.. .
>

Application Name

Hi
Does anyone know how the ODBC driver gets the application name that is
displayed by the SQL Server profiler? Our application does not explicitly
pass it in with the connection string but we are seeing a name under the
ApplicationName column in SQL Server profiler.
Many thanks
ShaktiI'm just curious. Does the application name that is generated make sense?
I
know that if I don't set one in ADO.Net, the app name is something like ".ne
t
client." If I need the information to say something that I really need to
set the AppName
--
Russel Loski, MCSD.Net
"Johnny" wrote:

> Hi
> Does anyone know how the ODBC driver gets the application name that is
> displayed by the SQL Server profiler? Our application does not explicitly
> pass it in with the connection string but we are seeing a name under the
> ApplicationName column in SQL Server profiler.
> Many thanks
> Shakti
>
>|||Hi,
there are several way, one would be to tweak the connection string with
the appName parameter.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||Agree that your suggestion is the way to set the application name but if it
is not set by the application where does it get the name from? I can see
the program name in the sysprocesses table but if the application is not
setting it explicitly where does it come from?
Thanks
Shakti
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169569609.022799.219340@.l53g2000cwa.googlegroups.com...
> Hi,
> there are several way, one would be to tweak the connection string with
> the appName parameter.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||Still from the application side. It's a parameter for the
connection string, property for the connection, different
ways depending on the application.Not all connections from
applications will supply them.
-Sue
On Tue, 23 Jan 2007 20:39:32 -0000, "johnny"
<prem14@.acm.org> wrote:

>Agree that your suggestion is the way to set the application name but if it
>is not set by the application where does it get the name from? I can see
>the program name in the sysprocesses table but if the application is not
>setting it explicitly where does it come from?
>Thanks
>Shakti
>"Jens" <Jens@.sqlserver2005.de> wrote in message
>news:1169569609.022799.219340@.l53g2000cwa.googlegroups.com...
>|||We are going round in circles! Application is neither supplying the
application name parameter nor setting any connection property whatsoever.
So, where does ODBC driver / sql server / sysprocesses get the program name
from? It appears to have our company name!
Cheers
Shakti
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:m9hdr2h8qehp2c1q96jibubcmd44s900ht@.
4ax.com...
> Still from the application side. It's a parameter for the
> connection string, property for the connection, different
> ways depending on the application.Not all connections from
> applications will supply them.
> -Sue
> On Tue, 23 Jan 2007 20:39:32 -0000, "johnny"
> <prem14@.acm.org> wrote:
>
>|||Client would have been the better word to use rather than
application. It depends on what application.you are using.
And driver.
-Sue
On Wed, 24 Jan 2007 11:30:36 -0000, "Johnny"
<prem14@.acm.org> wrote:

>We are going round in circles! Application is neither supplying the
>application name parameter nor setting any connection property whatsoever.
>So, where does ODBC driver / sql server / sysprocesses get the program name
>from? It appears to have our company name!
>Cheers
>Shakti
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:m9hdr2h8qehp2c1q96jibubcmd44s900ht@.
4ax.com...
>