I would expect to see gradual memory loss during the day but to jump from 331Mb free at 23:59 to 144 Mb free at 00:00 (we have perfmon running all...

Try this version - we use it successfully to import an excel file

FROM OpenRowset

('MSDASQL', -- Provider name

'Driver=Microsoft Excel Driver (*.xls);

DBQ=xxxx.xls',-- datasource; filename

'SELECT * FROM [sheet1$]') as NewRates--sheet name...

Many thanks

Thanks for all your help folks..my boss came up with a solution using a temp table and a user defined function to get round the problem.

June Johnston

june.johnston@hrplc.co.uk

The table contains various languages with a phrase in english, to be translated into various languages (including Italian, German, French etc).

It is storing all kinds of phrases not just dates.

The...

I just reinstalled SP2 and have solved the problem.

My SP2 was installed before Analysis Manager

Thanks folks

That is exactly what we have done - our live box was showing the fill factor, while dev boxes did not.

Yes we have maintenance plans and yes I have just checked they are reorganised with 10% free space.

Thank u so much

June Johnston

June.Johnston@hrplc.co.uk

Thanks for that, but I am trying to determine what is causing this to be set when tables are created.

When I create a table and then modify the index in...

Thanks for your reply - and sorry for the delay in answering (we had a Bank Holiday over here !!)

I have SP2 loaded on my machine (I assume it includes...

Okies, thanks for that.

Thanks for that