2 different Unicode Collation

[DBA2RELOADED]

I'm trying combined 2 sql servers (7.0) to 1 sql servers (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.

 

[nigelrivett]

v2000 supports databases with different collations but you will have problems if the database does not heve the same collation as tempdb and you use temp tables. Might be easier to have another instance of sql server with the different collation.

You can also specify the collation at the column level but this will still cause problems and probably mean a lot of work.

Changing the collation of the database on the transfer would be easiest but it's a business decision as to whether or not this will cause problems.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.