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

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.