How do I change the language sorting code to a specific language in SQL / MSDE? (NETIQKB35462)

goal
How do I change the language sorting code to a specific language in SQL / MSDE?

fact
Exchange Migrator 2.2 SP1

fact
Exchange Migrator 2.3

fix

To change the language sorting code to a specific language:

Option 1

• Reinstall MSDE with the correct collation (this is the easiest option):
1. Uninstall MSDE through Add / RemovePrograms.
2. Run setup for MSDE using the corresponding command line switches.
• Please refer to the following Microsoft Knowledge Base article for more information on the MSDE/SQL installation command line switches:
  
  Customizing Desktop Engine Setup.exe
  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp

Option 2

1. Run a database creation script specifying a custom collation.
2. Install Exchange Migrator 2.2 SP 1 (2.21)  or later.
3. Copy database objects from the original EM database to the newly created database with custom collation.
4. Use \Program Files\NetIQ\Exchange Migrator\DBManager.exe to point Exchange Migrator to the new database.
•  DBManager.exe is available with the default installation of Exchange Migrator 2.3 or later, or with the installation of SP1 for Exchange Migrator 2.2. 

note

Please refer to the following Microsoft knowledge base article for more information:

How to transfer a database from one collation to another collation in SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;325335&Product=sql2k

note

For more information on possible issues that result from an incorrect sort order, please refer to the following NetIQ Knowledge Base article:

NETIQKB24379:  Exchange Migrator displays distorted international characters.

Formerly known as NETIQKB35462