how to change server collation in SQL Server 2008 R2

Question

how do I change the server collation setting from 'Chinese_PRC_CI_AS' to 'Latin1_General_CI_AS'?

Answer 1

This is not an easy process, according to this MSDN article: http://msdn.microsoft.com/en-us/library/ms179254.aspx

If it's possible, I'd recommend just changing the collation for each database, per this MSDN article: http://msdn.microsoft.com/en-us/library/ms175835.aspx

Answer 2

You can change the collation of "master" database/Server by rebuilding the database, for this go through to these links:

http://msdn.microsoft.com/en-us/library/dd207003(v=sql.100).aspx

http://sqlbuzz.wordpress.com/2011/08/20/how-to-rebuild-master-database-aka-rebuilding-sql-server-2008r2/

but make sure you backup all your database before doing this.