Thanks Guys,

What I'm trying to do in plain English is check for the success of an Overnight job that loads the data into the tables before running the subsequent reports agains...

Thanks Derek,

I have already done this but it doesn't work as expected.

Regards

Carl

I'm not sure whether they were set to read-only but I fully expected them to be overwritten myself.

Thanks for the reply.

I actually removed the files and was able to re-install without problems.  I am still confused as I managed to uninstall and re-install SQL Server before without...

Thanks for your help Terry.

I am aware of the SP4 AWE fix.

From posting to other Forums it seems that not you are not required to run ALL Hotfixes between Service...

I have already downloaded and installed that cumulative hotfix.  That is Hotfix 818.  I need to get to 878. 

As I could not get a difinitive answer I have just...

I am aware of SP4 it's just that the business won't buy into building the new server with SP4 on, as it needs building ASAP.  Whilst we have the test...

I have tried to get the business to buy into moving to SP4 but as the server needs rebuilding in a hurry they want to keep the Service Pack level...

Most of the hotfixes that I have checked between 818 and 878 don't have downloads with them.

I thought that hotfixes were executable download files for fixing bugs?

There is so much...

Guys,

I have just got back from holiday and have only just started looking into the Hotfixes situation again.

I found the following text on the following Microsoft web page:

Hi Brian

I am aware that @@VERSION tells you the current patch level but it doesn't tell you what hotfixes have been installed, just what the current level is.

Thanks for your help.

I didn't think they were cumulative but read somewhere that they supposedly were.

Carl

Thanks.

I ended up using the sp_change_users_login to resolve the orphaned user on the new server rather than dropping the user and recreating.

Thanks Anyway.

Carl

Thanks very much for all your advice.

I'll keep you informed with how things go.

Regards

Carl