Prologika Forums
Business Intelligence to the Masses

Report Model Generates SMQL -- Where do we find SQL ?

rated by 0 users
Answered (Verified) This post has 0 verified answers | 3 Replies | 2 Followers

Top 75 Contributor
6 Posts
tscoccol posted on Wed, Jan 27 2010 9:58 AM

I assume that the report server is converting the SMQL to SQL.  Short of running a trace on the server, is there any way to capture the SQL ?

Thanks.

All Replies

Top 10 Contributor
1,684 Posts
Reply
Teo Lachev replied on Wed, Jan 27 2010 12:20 PM

See 9.3.4.

Top 75 Contributor
6 Posts
Reply
tscoccol replied on Wed, Jan 27 2010 12:42 PM

Thanks Teo.  So basically, you have to have admin rights to capture the SQL.   That's unfortunate, makes the life of a developer a bit more difficult.

Top 10 Contributor
1,684 Posts
Reply
Teo Lachev replied on Wed, Jan 27 2010 12:57 PM

The first approach discussed in this section doesn't require admin rights. If you want, you can use a tracer, such as DebugView, to monitor the output in real time. Not sure what rights DebugView requires though.

Page 1 of 1 (4 items) | RSS
Copyright © 2005 Prologika, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems
3DZL:andrewbelon.com