[thelist] MSSQL 2000 -> 2005 change?

[Ed McCarroll]

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 ! 
>