如何更改SQL服务器安装时的地区,语言、排序。
sun5 2003-08-21 12:16:07 我重装SQL7时,选错了排序方式,和地区代码。安装成功后,想将旧的数据库A附加。但报错Server: Msg 1816, Level 16, State 1, Line 1
Could not attach the database because the character set, sort order, or Unicode collation for the database differs from this server.
Server: Msg 1816, Level 16, State 1, Line 1
Could not attach the database because the character set, sort order, or Unicode collation for the database differs from this server.
Warning: sort order 51 in database differs from server sort order of 199.
Warning: Unicode language locale 1033 in database differs from server Unicode language locale of 2052.
Warning: Unicode comparison flags 196608 in database differs from server Unicode comparison flags of 196609.
Warning: sort order 51 in database differs from server sort order of 199.
Warning: Unicode language locale 1033 in database differs from server Unicode language locale of 2052.
Warning: Unicode comparison flags 196608 in database differs from server Unicode comparison flags of 196609.
我察看系统表后,发现好像是在sysconfigures、syscurconfigs表中设置的。
我直接在企业管理器更改了sysconfigures表,但
我使用sp_configure 'allow update', 1语句后,尝试修改syscurconfigs表中设置
却提示不能修改。
不知是否有其它简单指令,修改这些参数。