monitor your memory on the SQL server side.  we had an issue about 6 months ago where the table (views) that we query to began to consume all server memory....

great info. thanks, steve.

site owners: this should be made sticky!

a child is 1 hierarchal step down from the parent. a descendent is any member found down from the parent to the last leaf-level member.

cant help you any further -...

^bump^

use a view as your source table and put the filter in the where clause.

i dont think there is any easy way to do this. the security roles are stored in the olap repository (access db by default or you can migrate to a...

thanks guys.

any ideas for analysis (services) manager?

No data was added. The emtpy test db is created as 10GB, when I restore the backup from the prod copy that I deleted the data in, the test db...

Oh but it is....it's a raid controller error!

FYI, I misspoke. 20GB isnt the original size of the prod db, it's the current size. The original size is probably 1GB or so.

I might try the SHRINKFILE tomorrow....

Thanks!  This worked perfectly:

Right click on empty space in your DTS designer window

Choose "Disconnected Edit..."

Open up the connections

Open up your Excel Connection

Look in the OLE DB Properties of the connection

The...

Thanks, I'll take a look at this today. I had a feeling that WIndows Authentication was making it more difficult than it should be.

BTW, I was trying to set...

Ok, first maybe I need clarification on what is actually being timed in Analysis Services. I presumed it was then the result set was returned to the client. Correct me...

Query loggin IS enabled.  Write to log once per "1" queries.

No partitions. Yet.

Anything else?

Did you get this fixed yet?  Some ideas...

You might want to try setting the timeout property to zero, which I believe is infinite (no timeout). What might be happening is that...