List of tables and columns used by SSRS Reports

49 Views Asked by At

I have a number of SSRS reports that extract data from a SQL Server database via a stored procedure. I wanted to know what tables are used by each report/stored procedure in the following format:

SP Name Table Column
SP1 tblOrder ID
SP1 tblOrder Volume
SP2 tblCust Name

ie: if a stored procedure uses 2 columns, there will be 2 rows.

Is there a SQL tool I can use to achieve this? SQL Profile/Trace?

Thanks in advance

0

There are 0 best solutions below