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 ?
Thanks
You 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
>
sql

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
>

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
>