[thelist] MSSQL 2000 -> 2005 change?
Ed McCarroll
Ed at ComSimplicity.com
Fri May 18 19:20:33 CDT 2007
Just a thought: Could your new machine be running in case-sensative
mode?
--------------------------------------------------------------------
Ed McCarroll (310) 838-4330
Ed at ComSimplicity.com http://www.ComSimplicity.com
Quoting Joel D Canfield <joel at streamliine.com>:
> 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
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list