Sorry All, Different Timezone here in SA.

We pull ALL the data for our daily summary tables over every day for a full financial year from Micros, this goes into...

Hi Guys

Did you ever manage to fix this as i am having a similar issue, but on SQL 2012.

Issue was been resolved by processing the Sales fact Dimension with Process full

Thanks Lempster

I have already added the filter for only the login of the user I wish to track, I will also check the books online.

Morning All

Thank you all very much, The issue we were having, it seemed that this server was a broken cluster and was reformatted. The issue was was that the old...

Thank you very much!

Thanks very much for you idea's

I did not get far with creating a linked server, then attempting to insert the tables( we couldnt even view the data )

so right now...

thanks very much and sorry again:(

Thanks and sorry for posting it in the wrong place

Thank you very much Mr Scarlett!

Tried with a new SQL 2005 install disk and it worked perfectly!