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

How to get next range of Ident values for Merge Replication

You can use sp_adjustpublisheridentityrange on the
publisher.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
Is there a method to specify what the next seed value should be?
Thanks
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:1bc101c4fd41$e9448560$a301280a@.phx.gbl...
> You can use sp_adjustpublisheridentityrange on the
> publisher.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||You could hack into MSrepl_identity_range but I
definitely wouldn't advise this. I know this sounds a
pain, but to avoid any issues like this, I'd consider
reinitializing and setting such a large range that this
can never be an issue in future - either that or manual
range management, but that can be difficult to set up if
you have a lot of subscribers.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)