SQL Connection Program Name

[Charles Collins]

Is there a way to set the program name for a connection so that it is a bit
more descriptive than ".Net SqlClient Data Provider"?

Thanks,
Charles

[Gerry O'Brien [MVP]]

Declare a variable to be of that type?

I'm not quite clear on what you are asking here.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)


"Charles Collins" <cj********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Is there a way to set the program name for a connection so that it is a
bit more descriptive than ".Net SqlClient Data Provider"?

Thanks,
Charles

[Greg Burns]

In your connection string add an "Application Name".

Like so:

<add key="ConnectionString"
value="server=MyServer;Trusted_Connection=true;dat abase=MyDB;Application
Name=MyApp"/>

It will show up in SQL Profiler as "MyApp". Great way to filter in
Profiler.

HTH,
Greg

"Charles Collins" <cj********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Is there a way to set the program name for a connection so that it is a
bit more descriptive than ".Net SqlClient Data Provider"?

Thanks,
Charles

[Drebin]

I think he means the 'application name' that is reported to SQL. Like if you
run "sp_who2" in SQL Query Analyzer, the column for ProgramName.

"Gerry O'Brien [MVP]" <gerry dot obrien at gmail dot com> wrote in message
news:ub**************@tk2msftngp13.phx.gbl...

Declare a variable to be of that type?

I'm not quite clear on what you are asking here.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)


"Charles Collins" <cj********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Is there a way to set the program name for a connection so that it is a
bit more descriptive than ".Net SqlClient Data Provider"?

Thanks,
Charles

[Charles Collins]

That's it, thanks.
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:uc**************@TK2MSFTNGP10.phx.gbl...

In your connection string add an "Application Name".

Like so:

<add key="ConnectionString"
value="server=MyServer;Trusted_Connection=true;dat abase=MyDB;Application
Name=MyApp"/>

It will show up in SQL Profiler as "MyApp". Great way to filter in
Profiler.

HTH,
Greg

"Charles Collins" <cj********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Is there a way to set the program name for a connection so that it is a
bit more descriptive than ".Net SqlClient Data Provider"?

Thanks,
Charles