Changing Server Collation on MS SQL Server
Changing the server collation of a SQL Server is not just a checkbox option. Specially if you have you have user databases on the server.
However and to make it simple for the purpose of this post, if in the case of just after installing your SQL Server you need to change your server collation, you can run one of the following commands, depending on which SQL Server version you are using.
For SQL Server 2005
Insert the media of SQL Server installation and run the command:
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=YOUR_PASSWORD SQLCOLLATION=Latin1_General_CI_AI
For SQL Server 2008
Insert the media of SQL Server installation and run the command:
setup.exe /q /ACTION=RebuildDatabase /INSTANCENAME=MSSQLSERVER /SAPWD="YOUR_SA_PASSWORD"
/SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /SqlCollation=Latin1_General_CI_AI
Hope it helps!