HOWTO: Change the collation of your database
Changing the collation of your database.
You can use the following query in Enterprise Manager or Management Studios against an SQL 2000 or 2005 database to change the collation:
USE Tempdb
GO
ALTER DATABASE (database name here) COLLATE (collation name here)
GO
(Note: remove parenthesis for database name and collation name)
Collation names:
(Language = Collation)
Afrikaans = Latin1_General_CI_AS
Albanian = Albanian_CI_AS
Arabic (Algeria) = Arabic_CI_AS
Arabic (Bahrain) = Arabic_CI_AS
Arabic (Egypt) = Arabic_CI_AS
Arabic (Iraq) = Arabic_CI_AS
Arabic (Jordan) = Arabic_CI_AS
Arabic (Kuwait) = Arabic_CI_AS
Arabic (Lebanon) = Arabic_CI_AS
Arabic (Libya) = Arabic_CI_AS
Arabic (Morocco) = Arabic_CI_AS
Arabic (Oman) = Arabic_CI_AS
Arabic (Qatar) = Arabic_CI_AS
Arabic (Saudi Arabia) = Arabic_CI_AS
Arabic (Syria) = Arabic_CI_AS
Arabic (Tunisia) = Arabic_CI_AS
Arabic (U.A.E.) = Arabic_CI_AS
Arabic (Yemen) = Arabic_CI_AS
Armenian (Republic of Armenia) = Latin1_General_CI_AS
Azeri-Cyrillic (Azerbaijan)1 = Azeri_Cyrillic_90_CI_AS
Azeri-Latin (Azerbaijan)1 = Azeri_Latin_90_CI_AS
Basque = Latin1_General_CI_AS
Belarusian = Cyrillic_General_CI_AS
Bulgarian = Cyrillic_General_CI_AS
Catalan = Latin1_General_CI_AS
Chinese (Hong Kong S.A.R.)1 = Chinese_Hong_Kong_Stroke_90_CI_AS
Chinese (Macau S.A.R.)2 = Chinese_PRC_90_CI_AS
Chinese (PRC)2 = Chinese_PRC_CI_AS
Chinese (PRC) = Chinese_PRC_Stroke_CI_AS
Chinese (Singapore) = Chinese_PRC_90_CI_AS
Chinese (Taiwan) = Chinese_Taiwan_Stroke_CI_AS
Chinese (Taiwan) = Chinese_Taiwan_Bopomofo_CI_AS
Croatian = Croatian_CI_AS
Czech = Czech_CI_AS
Danish = Danish_Norwegian_CI_AS
Divehi1 = Divehi_90_CI_AS (Unicode only)
Dutch (Belgium) = Latin1_General_CI_AS
Dutch (Netherlands) = Latin1_General_CI_AS
English (Australia) = Latin1_General_CI_AS
English (Belize) = Latin1_General_CI_AS
English (Canada) = Latin1_General_CI_AS
English (Caribbean) = Latin1_General_CI_AS
English (Hong Kong S.A.R.) = Latin1_General_CI_AS
English (India) = Latin1_General_CI_AS
English (Indonesia) = Latin1_General_CI_AS
English (Ireland) = Latin1_General_CI_AS
English (Jamaica) = Latin1_General_CI_AS
English (Malaysia) = Latin1_General_CI_AS
English (New Zealand) = Latin1_General_CI_AS
English (Philippines) = Latin1_General_CI_AS
English (Singapore) = Latin1_General_CI_AS
English (South Africa) = Latin1_General_CI_AS
English (Trinidad) = Latin1_General_CI_AS
English (United Kingdom) = Latin1_General_CI_AS
English (United States) = SQL_Latin1_General_CP1_CI_AS
English (Zimbabwe) = Latin1_General_CI_AS
Estonian = Estonian_CI_AS
Faeroese = Latin1_General_CI_AS
Farsi = Arabic_CI_AS
Finnish = Finnish_Swedish_CI_AS
French (Belgium) = French_CI_AS
French (Canada) = French_CI_AS
French (France) = French_CI_AS
French (Luxembourg) = French_CI_AS
French (Monaco) = French_CI_AS
French (Switzerland) = French_CI_AS
Galician (Spain) = Latin1_General_CI_AS
Georgian = Latin1_General_CI_AS
German (Austria) = Latin1_General_CI_AS
German (Germany) = Latin1_General_CI_AS
German (Liechtenstein) = Latin1_General_CI_AS
German (Luxembourg) = Latin1_General_CI_AS
German (Phone Book Sort) = German_PhoneBook_CI_AS
German (Switzerland) = Latin1_General_CI_AS
Greek = Greek_CI_AS
Gujarati (India)3 = Indic_General_90_CI_AS (Unicode only)
Hebrew = Hebrew_CI_AS
Hindi3 = Indic_General_90_CI_AS (Unicode only)
Hungarian = Hungarian_CI_AS
Hungarian (Technical) = Hungarian_Technical_CI_AS
Icelandic = Icelandic_CI_AS
Indonesian = Latin1_General_CI_AS
Italian (Italy) = Latin1_General_CI_AS
Italian (Switzerland) = Latin1_General_CI_AS
Japanese = Japanese_CI_AS
Kannada (India)3 = Indic_General_90_CI_AS (Unicode only)
Kazakh (Kazakstan)1 = Kazakh_90_CI_AS
Konkani (India)3 = Indic_General_90_CI_AS (Unicode only)
Korean (Extended Wansung) = Korean_Wansung_CI_AS
Kyrgyz-Cyrillic (Republic of Kyrgyztan) = Cyrillic_General_CI_AS
Latvian = Latvian_CI_AS
Lithuanian = Lithuanian_CI_AS
Macedonian (FYROM) = Macedonian_FYROM_90_CI_AS
Malay (Brunei Darussalam) = Latin1_General_CI_AS
Malay (Malaysia) = Latin1_General_CI_AS
Marathi (India)3 = Indic_General_90_CI_AS (Unicode only)
Mongolian-Cyrillic (Mongolia) = Cyrillic_General_CI_AS
Norwegian (Bokmal) = Danish_Norwegian_CI_AS
Norwegian (Nynorsk) = Danish_Norwegian_CI_AS
Polish = Polish_CI_AS
Portuguese (Brazil) = Latin1_General_CI_AS
Portuguese (Portugal) = Latin1_General_CI_AS
Punjab-Gurmuhki (India)3 = Indic_General_90_CI_AS (Unicode only)
Romanian = Romanian_CI_AS
Russian = Cyrillic_General_CI_AS
Sanskrit (India)3 = Indic_General_90_CI_AS (Unicode only)
Serbian (Cyrillic) = Cyrillic_General_CI_AS
Serbian (Latin) = Cyrillic_General_CI_AS
Slovak = Slovak_CI_AS
Slovenian = Slovenian_CI_AS
Spanish (Argentina) = Modern_Spanish_CI_AS
Spanish (Bolivia) = Modern_Spanish_CI_AS
Spanish (Chile) = Modern_Spanish_CI_AS
Spanish (Colombia) = Modern_Spanish_CI_AS
Spanish (Costa Rica) = Modern_Spanish_CI_AS
Spanish (Dominican Republic) = Modern_Spanish_CI_AS
Spanish (Ecuador) = Modern_Spanish_CI_AS
Spanish (El Salvador) = Modern_Spanish_CI_AS
Spanish (Guatemala) = Modern_Spanish_CI_AS
Spanish (Honduras) = Modern_Spanish_CI_AS
Spanish (International Sort) = Modern_Spanish_CI_AS
Spanish (Mexico) = Modern_Spanish_CI_AS
Spanish (Nicaragua) = Modern_Spanish_CI_AS
Spanish (Panama) = Modern_Spanish_CI_AS
Spanish (Paraguay) = Modern_Spanish_CI_AS
Spanish (Peru) = Modern_Spanish_CI_AS
Spanish (Puerto Rico) = Modern_Spanish_CI_AS
Spanish (Traditional Sort) = Traditional_Spanish_CI_AS
Spanish (Uruguay) = Modern_Spanish_CI_AS
Spanish (Venezuela) = Modern_Spanish_CI_AS
Swahili = Latin1_General_CI_AS
Swedish = Finnish_Swedish_CI_AS
Swedish (Finland) = Finnish_Swedish_CI_AS
Syriac (Syria)1 = Syriac_90_CI_AS (Unicode only)
Tamil (India)1 = Indic_General_90_CI_AS (Unicode only)
Tatar (Tatarstan)1 = Tatar_90_CI_AS
Telugu (India)1 = Indic_General_90_CI_AS (Unicode only)
Thai = Thai_CI_AS
Turkish = Turkish_CI_AS
Ukrainian = Ukrainian_CI_AS
Urdu = Arabic_CI_AS
Uzbek (Latin)1 = Uzbek_Latin_90_CI_AS
Uzbek-Cyrillic (Republic of Uzbeckistan) = Cyrillic_General_CI_AS
Vietnamese = Vietnamese_CI_AS