SQL Server 2000 SP3  
Author Message
Onesta





PostPosted: Wed Feb 25 09:15:21 CST 2004 Top

SQL Server >> SQL Server 2000 SP3

Hi.

In order to install SQL Server 2000 on a Windows 2003 Server, i had to
update it with SP3.
Are there any changes to the outer join clause in SQL Server 2000 SP3?
I have a database on a Win2K Server with SQL Server 2000, without any
servicepacks.
My query, which uses LEFT OUTER JOIN between to tables, returns all the rows
from the left table, and rows from the right table matching rows from the
left table.
On the new server, a Win2K3 server with SQL Server 2000 SP3, the very same
query returns only the rows from the left table which matches the rows in
the right table, similar to a simple JOIN.

I've taken a backup of the database from the Win2K server, and restored it
on the Win2K3 server in order to keep all keys, indexes and collation.
I have not backup/restored the MASTER database. Is this necessary?

Any help would be appreciated.

Thanks in advance.

Bjarne Anker

SQL Server105  
 
 
Brad





PostPosted: Wed Feb 25 09:15:21 CST 2004 Top

SQL Server >> SQL Server 2000 SP3
said...
>
> In order to install SQL Server 2000 on a Windows 2003 Server, i had to
> update it with SP3.
> Are there any changes to the outer join clause in SQL Server 2000 SP3?
> I have a database on a Win2K Server with SQL Server 2000, without any
> servicepacks.
> My query, which uses LEFT OUTER JOIN between to tables, returns all the rows
> from the left table, and rows from the right table matching rows from the
> left table.
> On the new server, a Win2K3 server with SQL Server 2000 SP3, the very same
> query returns only the rows from the left table which matches the rows in
> the right table, similar to a simple JOIN.
>
> I've taken a backup of the database from the Win2K server, and restored it
> on the Win2K3 server in order to keep all keys, indexes and collation.
> I have not backup/restored the MASTER database. Is this necessary?

That is a very strange issue. I have made the same kind of migration in
the past and I had no problems. I use left outers all of the time.
 
 
Bjarne





PostPosted: Fri Feb 27 03:12:52 CST 2004 Top

SQL Server >> SQL Server 2000 SP3 Yes, i find this very strange.
I tried to install the service pack on my local WinXP laptop with SQL Server
2000, and the exact same problem occured.
I guess I have no other choice than to call Microsoft Support....
Unless someone has å workaround?

BJ




> said...
> >
> > In order to install SQL Server 2000 on a Windows 2003 Server, i had to
> > update it with SP3.
> > Are there any changes to the outer join clause in SQL Server 2000 SP3?
> > I have a database on a Win2K Server with SQL Server 2000, without any
> > servicepacks.
> > My query, which uses LEFT OUTER JOIN between to tables, returns all the
rows
> > from the left table, and rows from the right table matching rows from
the
> > left table.
> > On the new server, a Win2K3 server with SQL Server 2000 SP3, the very
same
> > query returns only the rows from the left table which matches the rows
in
> > the right table, similar to a simple JOIN.
> >
> > I've taken a backup of the database from the Win2K server, and restored
it
> > on the Win2K3 server in order to keep all keys, indexes and collation.
> > I have not backup/restored the MASTER database. Is this necessary?
>
> That is a very strange issue. I have made the same kind of migration in
> the past and I had no problems. I use left outers all of the time.