We are experiencing issues with COLLATION and SQL2K scripts. Our software experiences frequent database changes and scripts are generated using SQL Enterprise from a single development database. These scripts are then distributed to a number (100's) of target databases. SQL2K scripting has a habit of including the COLLATION clause and this does not always match the target database when the script is run.

My first thought is to change the collation of all columns and the default collation on the target databases to be consistent but I hear that default collation cannot be changed.

Can anyone point me to any documentation or common practice to bring database collation into line.

Hope, these links help you in someways.

Using SQL Collations

Collation Options for International Support

SQL Server and Collation

Beware of Mixing Collation with SQL Server 2000 - Part 1

Beware of Mixing Collations: Part 2- Converting Collations

Cheers!

_________________________
- Vijay G
Strive for Perfection

Thanks "Happy". Have found some stuff on MSDN library too.