Sorry I meant management studio..

no it doesn't install...that

only configuration manager

Okay since I can't do an inline upgrade..I copied out the MDF & LDF.

then I uninstalled SQL 2000, rebooted.

when I install SQL 2005 it doesn't install Enterprise manager...when I look...

Thanks Nabha!

Exactly what I needed.

Good karma to you.

I figured it out

thanks anyway

Thank man...

It's saying invalid column name borrowerid

Thanks Mark!!

Go it, must be admin

Thanks guys..

Interesting responses..

Thanks guys!

Thankagain..

what if I need to add a where clause to the above query

Where l.branchoffice not in ('01','02')

Thanks Dave!!!

Thanks to the rest of you guys also!

Good karma to you!

Sorry Dave you are correct I meant to be on the 2005

how do I do that calculation?

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

select l.loanid, l.branchoffice, l.AcquiredFrom,

l.previouslnnum, b.lastname, b.firstmiddlename,

p.addressline1, p.addressline2, p.city,

p.state, p.zip, l.originalamt,

s.primstat, p.appraisalvalue, l.glplan

--FROM loan L, property P, borrower B, status s

FROM loan L

...

Okay..pretty sure I need the columns in the other tables

I have no idea how to do that can you give me an example?

That didn't work, here's the entire statment:

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

select distinct l.loanid, l.branchoffice, l.AcquiredFrom,

l.previouslnnum, b.lastname, b.firstmiddlename,

p.addressline1, p.addressline2, p.city,

p.state, p.zip, l.originalamt,

s.primstat, p.appraisalvalue, l.glplan

--FROM loan L, property P, borrower B,...

Thanks man