Different Unicode Collation

I'm trying to combine 2 sql servers (7.0) to 1 sql server
(2000). However, the 2 sql servers have two different
unicode collations:
One Server:
SQL Server's Unicode collation is:
'English' (ID = 1033).
Second server:
SQL Server's Unicode collation is:
'English' (ID = 2057).
Is it possible to combine them into 1 SQL Server (2000).
Currently, these SQL Servers are in version 7.
Thanks.Please see my response to the duplicate post in this group under the
heading "2 Different Unicode Collation".
Thanks,
Bart
--
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
Content-Class: urn:content-classes:message
From: "RG DBA" <anonymous@.discussions.microsoft.com>
Sender: "RG DBA" <anonymous@.discussions.microsoft.com>
Subject: Different Unicode Collation
Date: Thu, 13 Nov 2003 12:05:02 -0800
Lines: 19
Message-ID: <031801c3aa21$6c537f80$a301280a@.phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcOqIWxT5Y91hikTQE+u6lPJPIvlRw==Newsgroups: microsoft.public.sqlserver.server
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:316413
NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
X-Tomcat-NG: microsoft.public.sqlserver.server
I'm trying to combine 2 sql servers (7.0) to 1 sql server
(2000). However, the 2 sql servers have two different
unicode collations:
One Server:
SQL Server's Unicode collation is:
'English' (ID = 1033).
Second server:
SQL Server's Unicode collation is:
'English' (ID = 2057).
Is it possible to combine them into 1 SQL Server (2000).
Currently, these SQL Servers are in version 7.
Thanks.