Wednesday, March 28, 2012

Profile statements for sp_prepare/sp_execute

I see a lot of sp_execute statements and cannot find the SQL statements
behind it in profiler.. Eg: i see
exec sp_execute 1, 10, 1
and like thousands and thousands of those when i run the trace for a few
secs.
How can i find out whats being run from a SQL perspective ?
ThanksYou double posted this one. See the replies in the other ng.
--
Andrew J. Kelly SQL MVP
"Hassan" <hassan@.hotmail.com> wrote in message
news:%237mauKlxHHA.312@.TK2MSFTNGP04.phx.gbl...
>I see a lot of sp_execute statements and cannot find the SQL statements
>behind it in profiler.. Eg: i see
> exec sp_execute 1, 10, 1
> and like thousands and thousands of those when i run the trace for a few
> secs.
> How can i find out whats being run from a SQL perspective ?
> Thanks
>

No comments:

Post a Comment