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

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo

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

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like