[thelist] MSSQL 2000 -> 2005 change?

[Joel D Canfield]

I have 2000, client has 2005. I've scripted the db structure, which
script ran fine on the client's box. Connected remotely, copied data
from 2000 to 2005. Tried to run this query

  select 
    e.firstname, e.lastname, e.didid, e.department, e.title, 
    o.number, 
    p.patchportnumber, 
    s.portnumber, 
    a.description 
  from
    employees e
    left join offices o on e.officeid = o.id
    left join patchports p on p.officeid = o.id
    left join switchports s on p.switchportid = s.id
    left join assets a on s.assetid = a.id

it tells me that firstname, lastname, didid, department, title, number,
patchportnumber, and portnumber are not valid fields (it does not
mention description)

query runs fine on my 2000 box with identical structure and data. I
assume this is some fun new difference with 2005.

thoughts?

thanks

joel