Monday, February 13, 2012

ADO Application Name not showing up in SQL Server Profiler

I am using MS SQL Server 2005 and SQLOLEDB.1
I can't seem get to get my application name to show up for
SQL:BatchCompleted messages. It shows up in the SQL:BatchStarting,
SQL:StmtStarting and SQL:StmtCompleted events.
After the connection string is set, I append ";Application Name=MyApp".
Has anyone seen this? Am I missing something?"Isaac Alexander" <isaacNOSPAM@.goNOSPAMprocura.com> wrote in message
news:eucFm3ytGHA.3264@.TK2MSFTNGP03.phx.gbl...
>I am using MS SQL Server 2005 and SQLOLEDB.1
> I can't seem get to get my application name to show up for
> SQL:BatchCompleted messages. It shows up in the SQL:BatchStarting,
> SQL:StmtStarting and SQL:StmtCompleted events.
> After the connection string is set, I append ";Application Name=MyApp".
> Has anyone seen this? Am I missing something?
>
Please ignore this message. I'm still learning the 2005 SQL Profiler. I
started with the template and the SQL:BatchCompleted didn't include the
Application Name column. I added the stored procedure event with the
Application Name column, but it showed up blank on the SQL:BatchCompleted
event since it wasn't checked in the options.
... fun.

No comments:

Post a Comment