Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 132
  • Last Modified:

SQL Profiler show result of stored procedures

I am trying to find what stored procedure is being run, the parameter values sent down to it and the results of the stored procedure. Using SQL Profiler 2014 I can capture the sp but not the resulting SQL statements that are being run. Which SQL events must I turn on to see the SQL statement(s) that is run?
0
rwheeler23
Asked:
rwheeler23
1 Solution
 
CamilliaCommented:
Try SP:StmtCompleted.

You can also have SQL:BatchStarted and SQL:BatchCompleted for more detail in addition to above.
0
 
rwheeler23Author Commented:
Thanks.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now