关于修改SQLSERVER2005数据库的排序规则

Question

用sql语句“alter database master collate Chinese_RPC_Stroke;”，老出现“服务器: 消息 448，级别 16，状态 3，行 1
排序规则 'Chinese_RPC_Strok' 无效。
”的错误 问一下是怎么回事？？？谢谢！！！

Answer 1

而且好像也没有你说的那个排序规则，自创的吧？
SELECT * from ::fn_helpcollations()
where name like 'Chinese_PRC_Stroke%'
/*
name description
------- --------------
Chinese_PRC_Stroke_BIN Chinese-PRC-Stroke, binary sort
Chinese_PRC_Stroke_BIN2 Chinese-PRC-Stroke, binary code point comparison sort
Chinese_PRC_Stroke_CI_AI Chinese-PRC-Stroke, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive
Chinese_PRC_Stroke_CI_AI_WS Chinese-PRC-Stroke, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive
Chinese_PRC_Stroke_CI_AI_KS Chinese-PRC-Stroke, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive
Chinese_PRC_Stroke_CI_AI_KS_WS Chinese-PRC-Stroke, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive
Chinese_PRC_Stroke_CI_AS Chinese-PRC-Stroke, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
Chinese_PRC_Stroke_CI_AS_WS Chinese-PRC-Stroke, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive
Chinese_PRC_Stroke_CI_AS_KS Chinese-PRC-Stroke, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive
Chinese_PRC_Stroke_CI_AS_KS_WS Chinese-PRC-Stroke, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive
Chinese_PRC_Stroke_CS_AI Chinese-PRC-Stroke, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive
Chinese_PRC_Stroke_CS_AI_WS Chinese-PRC-Stroke, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive
Chinese_PRC_Stroke_CS_AI_KS Chinese-PRC-Stroke, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive
Chinese_PRC_Stroke_CS_AI_KS_WS Chinese-PRC-Stroke, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive
Chinese_PRC_Stroke_CS_AS Chinese-PRC-Stroke, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive
Chinese_PRC_Stroke_CS_AS_WS Chinese-PRC-Stroke, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive
Chinese_PRC_Stroke_CS_AS_KS Chinese-PRC-Stroke, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive
Chinese_PRC_Stroke_CS_AS_KS_WS Chinese-PRC-Stroke, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive
Chinese_PRC_Stroke_90_BIN Chinese-PRC-Stroke-90, binary sort
Chinese_PRC_Stroke_90_BIN2 Chinese-PRC-Stroke-90, binary code point comparison sort
Chinese_PRC_Stroke_90_CI_AI Chinese-PRC-Stroke-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive
Chinese_PRC_Stroke_90_CI_AI_WS Chinese-PRC-Stroke-90, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive
Chinese_PRC_Stroke_90_CI_AI_KS Chinese-PRC-Stroke-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive
Chinese_PRC_Stroke_90_CI_AI_KS_WS Chinese-PRC-Stroke-90, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive
Chinese_PRC_Stroke_90_CI_AS Chinese-PRC-Stroke-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
Chinese_PRC_Stroke_90_CI_AS_WS Chinese-PRC-Stroke-90, case-insensitive, accent-sensitive, kanatype-insensitive, width-sensitive
Chinese_PRC_Stroke_90_CI_AS_KS Chinese-PRC-Stroke-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-insensitive
Chinese_PRC_Stroke_90_CI_AS_KS_WS Chinese-PRC-Stroke-90, case-insensitive, accent-sensitive, kanatype-sensitive, width-sensitive
Chinese_PRC_Stroke_90_CS_AI Chinese-PRC-Stroke-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-insensitive
Chinese_PRC_Stroke_90_CS_AI_WS Chinese-PRC-Stroke-90, case-sensitive, accent-insensitive, kanatype-insensitive, width-sensitive
Chinese_PRC_Stroke_90_CS_AI_KS Chinese-PRC-Stroke-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-insensitive
Chinese_PRC_Stroke_90_CS_AI_KS_WS Chinese-PRC-Stroke-90, case-sensitive, accent-insensitive, kanatype-sensitive, width-sensitive
Chinese_PRC_Stroke_90_CS_AS Chinese-PRC-Stroke-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive
Chinese_PRC_Stroke_90_CS_AS_WS Chinese-PRC-Stroke-90, case-sensitive, accent-sensitive, kanatype-insensitive, width-sensitive
Chinese_PRC_Stroke_90_CS_AS_KS Chinese-PRC-Stroke-90, case-sensitive, accent-sensitive, kanatype-sensitive, width-insensitive
Chinese_PRC_Stroke_90_CS_AS_KS_WS Chinese-PRC-Stroke-90, case-sensitive, accent-sensitive, kanatype-sensitive, width-sensitive
*/

Answer 2

用这个“alter database master collate Chinese_PRC_CI_AS;”，出现“服务器: 消息 3708，级别 16，状态 5，行 1
无法 更改 数据库 'master'，因为它是系统 数据库。"的错误？？？怎么回事，系统数据库不是可以更改么？？