Post reply

How to view the queries of standard reports?

  • June 10, 2011 at 9:29 am

    #241063

    When you right click on a database in SSMS and select Reports/Standard reports, you can select from a number of standard reports to run. Is there a way to see the queries behind those reports?

    Thanks!

  • June 10, 2011 at 9:33 am

    #1337076

    I'm not sure if this is the best way but you could run profiler then generate the report, this will give you the sql thats been passed to the server

  • June 10, 2011 at 9:59 am

    #1337100

    This definitely does it! Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply