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
>
Wednesday, March 28, 2012
Profile statements for sp_prepare/sp_execute
Labels:
1and,
database,
microsoft,
mysql,
oracle,
profiler,
seeexec,
server,
sp_execute,
sp_prepare,
sql,
statements,
statementsbehind,
thousands
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment