Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2007-08-15 : 11:38:13
|
| Folks:We have users who have reports generated using SQL 2005 Reporting Services. I would like to know how to find which SQL Queries/Stored Procedures they are executing/calling when running these reports. Is there a Table or directory where it stores the SQL?Thanks ! |
|
|
scottd
Starting Member
11 Posts |
Posted - 2007-08-17 : 12:02:25
|
| Hi, If these were designed with embeded code,take a look at the .rdl file. There is XML in the .rdl file for the report. Here, near the bottom of the codeyou should find the SQL. goodluck..Scott |
 |
|
|
|
|
|
Reporting Services - SQL Code