"paul" <paul@discussions.microsoft.com> wrote in message
news:EBF75E31-1A0A-42AD-806E-1009DFE9D3D7@microsoft.com...
> Does anyone know how, if possible at all, to modify the application name
> that
> appears in the Activity Monitor(Sql2K5), Current Activity(Sql2K) or
> sysprocesses table.
>
> We have multiple C# applications connecting to the same db but it is
> becoming hard to determine which application is using which connection and
> the only application name that shows up in the activity monitor or
> sysprocesses table is '.NET SqlClient Data Provider'
>
> thanks

"Roger Wolter[MSFT]" wrote:

> Try setting Application Name in the connection string
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "paul" <paul@discussions.microsoft.com> wrote in message
> news:EBF75E31-1A0A-42AD-806E-1009DFE9D3D7@microsoft.com...
> > Does anyone know how, if possible at all, to modify the application name
> > that
> > appears in the Activity Monitor(Sql2K5), Current Activity(Sql2K) or
> > sysprocesses table.
> >
> > We have multiple C# applications connecting to the same db but it is
> > becoming hard to determine which application is using which connection and
> > the only application name that shows up in the activity monitor or
> > sysprocesses table is '.NET SqlClient Data Provider'
> >
> > thanks
>
>
> .