"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
> ---
>

"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:
>
>>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
>>> ---
>>>
>>
>

<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...
>> 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...
>>>> 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
>>>> ---
>>>>
>>>
>>
>