How to view SQL being sent to the server?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gte401e - 29 Mar 2006 22:51 GMT

Using SQL Server 2k5 Report Designer. When I run a report, how do I
view the SQL generated by the report populated with parameters that
is/was/will be sent to the server?

Thanks

Reply to this Message

Geoff N. Hiten - 29 Mar 2006 23:11 GMT

The SQL Profiler tool is what you are looking for. Be careful running this
tool against a production system, especially one with high transaction
volumes. You can severely impact system performance very easily. Read
first, then test, then deploy.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Using SQL Server 2k5 Report Designer. When I run a report, how do I
> view the SQL generated by the report populated with parameters that
> is/was/will be sent to the server?
>
> Thanks

Reply to this Message

gte401e - 30 Mar 2006 17:28 GMT

Tried Profiler and I'm not seeing the entire SQL statement generated
from the report. Is there a way I can see the Where clause?
Thanks

Reply to this Message

Geoff N. Hiten - 30 Mar 2006 19:48 GMT

The TextData column should show the entire SQL Statement. You may have to
click on the statement to get it to appear fully in the lower window.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Tried Profiler and I'm not seeing the entire SQL statement generated
> from the report. Is there a way I can see the Where clause?
> Thanks

Reply to this Message

Amarnath - 31 Mar 2006 08:02 GMT

If not trying with sql profiler due to high volume try opening executionLog
table in the report server database, find your latest run report. but you can
see only the parameters you had passed.

Amarnath

> The SQL Profiler tool is what you are looking for. Be careful running this
> tool against a production system, especially one with high transaction
[quoted text clipped - 6 lines]
> >
> > Thanks

Reply to this Message