How do I change the sort-order or character set for a SQL Server database?

A. A. Basically you can't. You have to get these parameters correct when you install SQL. You will have to :-

• Backup your data and objects using bcp/transfer manager (NOT dump database)
• Re-install SQL Server with the correct sort-order/character set
• Re-load the data and objects

Contributed by Neil Pike