Change default Collation in SQL Server 2005

I recently had some trouble selecting the proper Collation/Sort order when setting up a new SQL 2005 installation. There was a small number of Collations/Sort Orders but not the one I needed.

The official webpage for that didn’t give much but I managed to find a command line syntax that fixed the problem, and I was able to specify Collation that wasn’t available during installation.

The syntax goes like this:

start /wait D:\SQLInstall\setup.exe /qb INSTANCENAME=MSSQLSERVER 
REINSTALL=SQL_Engine REBUILDDATABASE=1 
SAPWD=mysapassword SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

If you want to perform the rebuild without any output, run it with /qn instead of /qb

 

This entry was posted in SQL Server. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *