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.
Showing posts with label forsqlbatchcompleted. Show all posts
Showing posts with label forsqlbatchcompleted. Show all posts
Monday, February 13, 2012
Subscribe to:
Posts (Atom)