changing the collation on a sql | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

changing the collation on a sql

I installed sql server taking the default for collation but in this case I should have taken SQL_Latin1_General_CP1_CI_AS Latin1-General – does anyone know the command to change the collation of a server without having to re-install?
To change these settings, you must rebuild the master and user databases. Keep in mind that SQL Server 2000 has more flexibility for managing collations. You can change the default collation of a database after it’s been installed and change or set collations at the column level for existing tables. By changing the default collation of a database in SQL Server 2000 defines the collation of newly created objects but doesn’t automatically change the collations of existing objects. You can define the collation setting to a database/table/column level. Refer to the books online for more information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.