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