how do I change the server collation setting from 'Chinese_PRC_CI_AS' to 'Latin1_General_CI_AS'?
如何将服务器排序规则设置从“Chinese_PRC_CI_AS”更改为“Latin1_General_CI_AS”？
2 个解决方案
#1
11
This is not an easy process, according to this MSDN article: http://msdn.microsoft.com/en-us/library/ms179254.aspx
根据这篇MSDN文章，这不是一个简单的过程：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
如果可能，我建议只更改每个数据库的排序规则，根据这篇MSDN文章：http：//msdn.microsoft.com/en-us/library/ms175835.aspx
#2
3
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://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.
但请确保在执行此操作之前备份所有数据库。
#1
11
This is not an easy process, according to this MSDN article: http://msdn.microsoft.com/en-us/library/ms179254.aspx
根据这篇MSDN文章，这不是一个简单的过程：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
如果可能，我建议只更改每个数据库的排序规则，根据这篇MSDN文章：http：//msdn.microsoft.com/en-us/library/ms175835.aspx
#2
3
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://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.
但请确保在执行此操作之前备份所有数据库。