How to retrieve the SQL query generated by processing a cube in ASSAS

I have seen several posts which talk about looking at the underlying SQL for a cube in SQL Server 2005, but I have been unable to locate where you can do this. When I process my cube I do not see any SQL in the Process progress dialog box in the way you do with AS2000.

I have tried running SQL profiler while processing but that didn't give anything either.

Could someone help me out please?

Thanks

In the processing progress dialog box, you should be able to expand the items listed and eventually get down to the detail of the SQL queries generated and executed.

However, I find that using SQL Server Profiler works better if your source for the SSAS database is a SQL Server database. When you use Profiler, you need to profile the SQL Server database, not the SSAS database. Profiling the SQL Server database should show the queries hitting the database.

HTH,

Dave Fackler

how to retrieve full text of procedure definition from syscomment

Hello,
I am trying to locate where/when data is being inserted into a table from a
DB I recently inherited. So I write this in QA
select * from syscomments where
text like '%Insert Into CompareSubscribers%'
This will retrieve the procedure(s) that contains the text "...Insert
Into..." But when I select that text field from QA Results, and paste it
into Notepad, I only get the characters before the first carriage retuen.
How can I retrieve the full text? Or if I stretch out the field in QA
Results grid - it only stretches to the first carriage return in the text.
Thanks,
RichHi Rich
Why don't you try returning the results in text format instead of grid? And
only select the text column:
select text from syscomments where
text like '%Insert Into CompareSubscribers%'
Make sure you configure QA to return the full column width.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:164BF9D0-FEDE-4B37-8CAE-9A8F7257F118@.microsoft.com...
> Hello,
> I am trying to locate where/when data is being inserted into a table from
> a
> DB I recently inherited. So I write this in QA
> select * from syscomments where
> text like '%Insert Into CompareSubscribers%'
> This will retrieve the procedure(s) that contains the text "...Insert
> Into..." But when I select that text field from QA Results, and paste it
> into Notepad, I only get the characters before the first carriage retuen.
> How can I retrieve the full text? Or if I stretch out the field in QA
> Results grid - it only stretches to the first carriage return in the text.
> Thanks,
> Rich