Solved

SQL Profiler show result of stored procedures

Posted on 2015-02-07
2
107 Views
Last Modified: 2015-02-07
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
Comment
Question by:rwheeler23
2 Comments
 
LVL 7

Accepted Solution

by:
Camillia earned 500 total points
ID: 40595971
Try SP:StmtCompleted.

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

Author Closing Comment

by:rwheeler23
ID: 40596107
Thanks.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question