How to get the SQL from a Report Builder ?

Hi,

I am trying to extract the SQL out of a Report Builder Report. As recommended in a msdn article, I have enabled the trace flag as below

"add name="Components" value="all,RunningJobs:3,SemanticQueryEngine:4,SemanticModelGenerator:2" .

However i still do not see the SQL in the log files.

Can you please help me on this ?

Hi there,

You could try to use SQL Profiler and run a trace against the server.

cheers,

Andrew

|||

Hi Andrew,

Thanks for your reply. Just wanted to know, Is there any way other than profiler. Any idea ?

Thanks again,

Sam