How to Change Database Collation in SQL 2000.
Information in this Brief applies to:
StarTeam requires a Case Insensitive collation of the SQL database being used by StarTeam in order to perform the necessary functions of creating new configurations or upgrading from older 4.x configurations. Failure to have a Case Insensitive collation will cause a variety of different errors.
In order to change the SQL collation of a database in SQL 2000 there is a command that can be executed in the SQL Query Analyzer to perform such an operation. In order to run such command the following will need to be performed: