Sunday, November 16, 2008

Change the SQL server collation

To change the collation of the server, we must rebuild the master database.
The following command can do the trick:

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI

You cannot change the collation of a database. You must export, delete the database and import the data in the newly created database.

Default path to run this command: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap"


No comments: