Collations on SQL Server 2000
Trying to copy a Database from SQLDBA1 to SQLDEV3:
-----------------------------
Format:
Server:
Server Collation
Database
Database Collation
------------------------------
SQLDBA1:
SQL_Latin1_General_CP1_CI_ASSalestrackSQL_Latin1_General_CP1_CI_AS
SQLDEV3:
Latin1_General_BinSalestrackSQL_Latin1_General_CP1_CI_AS
SQLDEV3\SQLDEV3INST1:
SQL_Latin1_General_CP1_CI_ASSalestrackSQL_Latin1_General_CP1_CI_AS
DTS the databases from SQLDBA1 to SQLDEV3, the database was case-sensitive after the copy. ?????? WHY ????
DTS the database from SQLDBA1 to SQLDEV3\SQLDEV3INST1, the database was not case-sensitive.
WHAT IS UP WITH THIS ???