Thanks for that, I thought the same and was wondering if there's a way in 2005 without hacking the registry. I guess a clean install is a better way forward.

Thanks guys all your comments much appreciated. What I decided to do is revert to a backup and then populate the tables accordingly and then upgrade the database to required...

Thanks guys I will give all your suggestions a go. To answer the other question as to why the table needs to be dropped, it's simply because the data in...

So no easy solution then?

unfortunately there's more than one reference table, so deleting from the child tables will take a long time.

thanks it worked like a charm

I generated the DDL which included everything which made me think there must be a way to generate only the indexes and delete as appropriate.

I thought as much,  thanks guys.

Never mind guys, because i haven't done the account change in some yrs now I left out the local admin. bit probably after a weekend to remember...

I've taken a copy of the database that works and restored as the failed one and now i'm waiting for the application guys to send another message through.

thanks for the response but it does not help much...

Thanks for your response so far much appreciated and i thought exactly the same

you can read more about event id 322 from the link below

http://www.mcse.ms/archive82-2005-1-1286847.html

No they are not user defined. I was trying to see if I can generate the event IDs especially 322. I can generate event id 17052 in the application event...

Hi John

I tried the above steps but can't seem to regenerate the event ids e.g. 322 and 103. Any response much appreciated.