Thank you all for your suggestions.

I'll check the db for any incostistencies.

thanks again

Even Microsoft recommends not upgrading. Instead, they recommend building a new cluster then installing 2005. There was an article on MS's site a while back.

Have you tried scripting the database and all its objects?

Here you go

--Query 1

select count(*)

from [dbo].[vSection] AS [t0],

[dbo].[vTalentCriteria] AS [t1],

[dbo].[vTalentProfileAttribute] AS [t2],

...

Thank you.

I ended up recreating from scratch.

Thank you Steve.

Thanks,

I'll post the results when I attempt it.

Thanks Chiraq,

I know you can't. I learned the hard way, by trying the actual restore. I was just wondering if anyone has tried it differently and succeeded.

Thanks

Must be an Oracle error then. This query should work in SQL 2000/2005. I have never worked with Oracle databases before. If I find anything, I'll let you know. If...

Which one of the columns in the query has any of those data types?

Sorry Robert,

first day back since the holidays. Took me a while to register :-).

You only need one group by.

do this: group by

title,

firstname,

surname,

required_date,

address1,

birth_date,

request,

home_phone,

req_id,

user_name,

event_number,

acc_number,

nhi

try to run it without the count(*) at the end

You're missing the firstname in your group by clause.

Yeah,

I'm blessed that way. My company spends money on hardware like candy. 🙂

Thanks Rudy.

I have a spare cluster. I'll be installing SQL 2000 in it, to make as identical as possible to the production cluster. Will test it there first, then I'll...