Queires run as part of stored procedures, SQL server 2008R2
Posted on 2014-01-22
I have an application that runs a stored procedure, behind which is a myriad of other stored procs and functions. I ran the main stored proc with execution plan, and that shows 125 different queries were run.
What I want to do is get a list of all of those queries thru T-SQL. The execution plan gets this info, so it should be possible.
Thanks in advance.