Hello,

The question I asked myself, was while building a course on adomd.net.

The solution I have found, is that The administrator of SSAS server can be the application pool windows user...

Perfect, thanks.

We are actually testing this today.

We do not use Excel for this project, We use adomd.net with C# and asp.net.

I will update the thread with additional information on the...

Thank you.

This assures us the problem is not as major as we though it could be.

we will create an action plan, and wait for our manager to get started.

Thanks again,...

Thank you very much, for your reply.

This gives us more to think about, in matter of solutions.

For the execution plan, when we check, this is what it looks like

Here's a...

Thank you for your reply,

>> Have you checked the execution plans of the 8sec queries?

Not in great detail (we have 3 joins in the query in question).

>>Does that index get...

Hello hammad772001,

We have done the same as you, a restore of sql 2005 database to an sql 2008 database.

The way to verify syntax of procedures and vues, is to be...

Hello Everyone,

First, thanks to all for the advice. At first, I did not follow naming conventions used by the client, as he had none defined in a document. Now that...

Thanks Shawn.

so much for access and tbl_ 🙂 (Access is Access, and SQL Server is SQL Server I would say).

That application is a tuff one (4000 lines of code for...