CODEWITHSUNDEEP
sql-server-2008t-sqlreporting-servicesvisual-studio-2008ssrs-2008
fdkgfosfskjdlsjdlkfsf
fdkgfosfskjdlsjdlkfsf

Reputation: 3303

Way to find what stored procedure/script is behind SSRS report?

I have read access to the tables, stored procedures, and functions from a sql server database. I can also view the generated SSRS report from a browser. I just don't have access to the actual SSRS report.

Is there a way to know what stored procedure or tsql script is run when a report is generated?

Thanks.

Upvotes: 2

Views: 1617

Answers (2)

Pedram
Pedram

Reputation: 6508

There is no any way to find which stored procedure is calling behind SSRS Report without .RDL file of that SSRS report.

If you have access of database then you can check using SQL Server Profiler. Also, to check this log you must have administrator credentials.

Upvotes: 2

a415
a415

Reputation: 369

If there is a particular account that is utilized to run the report, you can utilize the MSSQL activity monitor from the management studio and see the view/query that is run from there.

Upvotes: 2

Related Questions