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 |
|
ARC
Starting Member
10 Posts |
 Posted - 2007-01-24 : 06:41:56
|
| Hi, I'm supporting Report Builder to a failly large number of users. It would be very useful when trying to work out what is goung wrong with their reports if I couold simply look at the SQL that the report is generating.Does anybody know of a way to do this?Thanks in anticipation. |
|
|
ARC
Starting Member
10 Posts |
Posted - 2007-02-07 : 07:49:28
|
| found out how to do this, you run the profilerwhen the report is running and then search for the host you are running your RS on in the HostName column. one of the rows will contain the event where your sql is fired at the db. |
 |
|
|
|
|
|
Seeing the SQL the Report Builder Generates