Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Profiler with embedded SQL
28 views
Skip to first unread message
Rachel
Sep 28, 2004, 8:17:45 AM9/28/04
to
Hi,
I'm wondering if there is some way for me to see via the
Profiler what the actual Transact-SQL is when the code is
embedded in the application. The app is using jdbc and
all that I see is exec
sp_execute 'param', 'param', 'param'. I'd like to see
what is being executed. Can I?
Please help!
I'm wondering if there is some way for me to see via the
Profiler what the actual Transact-SQL is when the code is
embedded in the application. The app is using jdbc and
all that I see is exec
sp_execute 'param', 'param', 'param'. I'd like to see
what is being executed. Can I?
Please help!
Jacco Schalkwijk
Sep 28, 2004, 8:28:34 AM9/28/04
to
Somewhat before the sp_execute in the Profiler trace you should see
sp_prepare statements, for which the parameter @P1 is the same as the
parameter @P1 for the sp_execute statement. That is the T-SQL statement that
is prepared and later executed with sp_execute.
sp_prepare statements, for which the parameter @P1 is the same as the
parameter @P1 for the sp_execute statement. That is the T-SQL statement that
is prepared and later executed with sp_execute.
--
Jacco Schalkwijk
SQL Server MVP
"Rachel" <anon...@discussions.microsoft.com> wrote in message
news:436c01c4a555$2946de50$a401...@phx.gbl...
0 new messages