Prepared Statements

• Adrian Sims-164328

  SSC Journeyman

  Points: 94

  More actions

  December 10, 2004 at 5:34 am

  #108908

  Hi,

  Apart from running SQL profile continually is there any way to find the SQL associated to a prepared statement.

  Also when the prepared statement is executed at run time with sp_execute, DBCC INPUTBUFFER ( spid )  just returns

   sp_execute;1

  without the parameters. How can the parameters be found ? 

   

• Adrian Sims-164328

  SSC Journeyman

  Points: 94

  More actions

  June 14, 2005 at 2:05 am

  #565191

  Just in case anyone needs the answer, the trick is to add the EventClass Event to SQL profile , and filter on the following Events:

  RPC:Completed

  SP:StmtCompleted

  and you will see the raw SQL