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.