MS SQL Server - Profiler Question

Author

Profiler Question

John GI

2006-03-09, 9:23 am

I have a query recently converted to a "prepared" statement using ADO
property known as Prepared = True. Since I have done that, I cannot see the
execution of the SQL statement/prepared SP in the SQL Profiler. This query
is constantly fed with parameters so that we get the upto date information
on the client screen. The screen is updated constantly but I don't see
feeding of parameters either. What events in profiler should I look for to
display this information? Thanks for the help!!!

Please forgive me if I posted it in the wrong newsgroup.

ivanpe@online.microsoft.com

2006-03-09, 1:23 pm

Have you tried "Exec Prepared SQL" event.

Thanks,
-Ivan

-----Original Message-----
From: John GI
Posted At: Thursday, March 09, 2006 5:57 AM
Posted To: microsoft.public.sqlserver.server
Conversation: Profiler Question
Subject: Profiler Question

I have a query recently converted to a "prepared" statement using ADO property known as Prepared = True. Since I have done that, I cannot see the execution of the SQL statement/prepared SP in the SQL Profiler. This query is constantly fed with parameter
s so that we get the upto date information on the client screen. The screen is updated constantly but I don't see feeding of parameters either. What events in profiler should I look for to display this information? Thanks for the help!!!

Please forgive me if I posted it in the wrong newsgroup.

Sponsored Links