Profile statements for sp_prepare/sp_execute

You double posted this one. See the replies in the other ng.

--
Andrew J. Kelly SQL MVP

"Hassan" 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
>