MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
FAQ  
Administration  
Backup/Restore  
Connectivity  
Development  
General  
Installation  
OLAP  
Replication  
Transfer/move  
Trouble  
SQL 6.5  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
History  
Search  
Traffic  
Related Links  
     
Your button logo
Add to Favorites
 
     
 


How can I change the sort order and character set?

Answer:

You cannot make it without rebuilding your databases.
This is from SQL Server Books Online:

It is critical that you select the correct sort order when you install SQL Server.
If you need to change sort orders after installation, you must rebuild your
databases and reload your data.
and

It is critical that you select the correct character set when you install SQL Server.
To change character sets after installing SQL Server, you must rebuild the databases
and reload the data.


 

 
Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

(c) 1997, 2005 Bits on the Wire, Inc