Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    114

    Unanswered: See query text from cache

    Hi,

    During a trace in profiler, I see some lines that indicate :
    Code:
    exec sp_execute 12
    Or
    Code:
    exec sp_execute 24
    I suppose these are query in cache and are recall by query processor ? If yes, how can I see this query in clear text ?

    Thanks for help

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Somewhere 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 .

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Mar 2004
    Posts
    114
    OK, I see. But I have not traced sp_prepare ... I am going to redo my trace

    Tahnk you for this information.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •